VB6 Controls not populating from Remote MySQL database

[Sprowler]

Hello everyone!

I have a problem which I hope you can help me with. I have created a VB6 app that connects to a web hosted MySQL database. I have created the connection string in my app and used the Port number required by the Web Host. All my data comes back to my VB forms when I run my app from my Win XP development machine, but here is my problem...

I have installed the app using InnoSetup wizard on a Win2K pc at SP4, and it connects successfully to the databases, but my textboxes, labels, comboboxes and datagrids show no data. For example, one of my forms has textboxes and a datagrid, and a statusbar. The textboxes and datagrid are bound to ADO controls which pass SQL statements to MySQL to create the recordset. The statusbar shows the RecordCount from the resulting recordset. The statusbar shows the correct recordset count, but the textboxes and datagrid are empty. This doesn't happen on my development machine.

In my installer, I have installed all the VB Runtime files to the target machines Windows\System32 directory, and have installed the OCX files the app uses to the application's directory.

I am at a complete loss to know why I can connect to the database, successfully open a recordset but not populate my forms' controls with the resulting data.

Your help is very much appreciated.

 

[Sprowler]

Hello everyone. Solved it myself. There were a couple of files missing in my installation pgm. MSBIND.dll seems particularly important as it appears to make the data bindings work. This is why I was getting no data on my forms.

Happy new year to all!