Migration: Access to MySQL with DAO

I am involved with a 'hobby' project. I have taken VB6 code and moved it to VB.Net. Painful, but done.

EDO was used to connect to a local Access (.MDB) backend. The Data and schema was copied to a MySQL server. IT works fine.

My question: Is it naive of me to think I can just change the connection string to point to the MySQL server instead of the .MDB file? I understand I have to add the username/password/database info but I cant seem to find a method to allow me to connect to anything but Access files.

Can someone pleas point me to some article or sample code? Google has not been helpfull.

And, yes, I understand this is an obsolete way of doing things.

Thanks, in advance,

0 answers