Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)

Quote Originally Posted by Jamie_Garland
I ament doing it through the PC's mysql server it's going through my websites mysql?
I've got no idea what that was supposed to mean, or how it was supposed to answer abhijit's question - and the best thing you can do at this stage is answer it.
Quote Originally Posted by MarkT
Do you have one of the "Microsoft ActiveX Data Objects 2.x Library" selected in the project references?
He must have, otherwise a different error would occur on the Dim lines.

This particular error occurs at the stage where ADO is attempting to communicate with the database driver, which means that the interaction between VB and ADO is fine.