MySQL and ADO
Posted on 2004-09-20
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,