Migration: Access to MySQL with DAO
Hello.
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,
Mike
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,
Mike
Selected Articles