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

0
edit delete
are you sure?
asked Mike Staines

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions