Trouble distributing datagrid

[raventhorn]

I have developed a simple application that uses a datagrid control to reflect the contents of a database. However, I have been having trouble distributing it onto other computers. It works fine on computer that have VB6 installed, but no others. These host computers have DCOM98 and MDAC 2.1 installed. Everytime my program is run I get the message "Cannot initialize data bindings". I'm assuming this means I have a missing or outdated control, but I cannot figure out what it would be. Any help would be appreciated.

--raven
([email protected])

[JHausmann]

Are you using the Package and deployment wizard to install your application?

[raventhorn]

Actually I'm using InstallShield Express to distribute it. However, I build an installation with the P&D Wizard to check the files that it included. I didn't see any differences between the two packages.

[Clunietp]

Are you using a MS Access 97 database? If so, you need to distribute MDAC 2.0 instead of 2.1.

2.0 includes drivers for Access 97 DBs and 2.1 includes drivers for Access 2000 DBs.

Tom

[Eclipse DevSoft]

See if the MS Data Binding Collection (msbind.dll) is included in your setup file. If you are using the Data control as your recordsource, make sure that the data control has its recordset open. This usually happens if you are using a Jet Database, hardcoding the location via the connection string. If you deploy your app and the target machine have a different folder structure than yours, the connection will fail. You can open a recordset and use it as the record source of the grid:

Set dtaGrid.DataSource = rs
dtaGrid.Rebind
dtaGrid.Refresh

This way, you don't have to use the data grid in conjunction with the data control. your recordset must be opened prior to assigning it to the grid.