MySQL and ADO

Hi.

I'm writing an application to allow migration of databases from one type to another.  The application will handle Access, SQL Server and MySQL database once it's done.

At the moment, I'm very happy with handling Access and SQL Server stuff, but I can't even create a connection to the MySQL server.

Can someone please advise me as to why I can't simply populate a connection string and set connected:=true to open a database connection to a MySQL server?

I'm using TADOConnection and TADOQuery to connect & read/write the databases.  I don't understand why this should be a problem as I have used loads of database types whilst programming before and have never come across this problem.

Thanks in advance,

John.
LVL 6
JaymolAsked:
Who is Participating?
 
Wim ten BrinkSelf-employed developerCommented:
AFAIK, there's no ADO provider for MySQL. There's one for MS-SQL, though. Spelled almost similar. To connect to MySQL you'll need an ODBC driver for it and connect through ADO to ODBC to MySQL.
0
 
JaymolAuthor Commented:
Could you explain a little more, maybe with a code example please.

I'm currently using this connection string....

"Driver={MySQL ODBC 3.51 Driver};Port=3306;Option=3;Server=Development;Database=TestDB;USER=root;PASSWORD=;"

Thanks.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
JaymolAuthor Commented:
Actually, don't bother - I've just reread what you've said and that's basically what I'm already doing.
0
 
gwalkeriqCommented:
Actually, there are some ADO drivers for MySQL. Never tried any of them myself - thought I would, so I had done a little research.  ADO.Net for MySql on Sourceforge.net and ByteFX.data on ByteFX.com also SevenObjects on SevenObjects.com



0
 
Mohammed NasmanSoftware DeveloperCommented:
Jaymol

  Did you Install MySql ODBC drivers in the computer that you testing from?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.