?
Solved

MySQL and ADO

Posted on 2004-09-20
6
Medium Priority
?
363 Views
Last Modified: 2013-11-23
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.
0
Comment
Question by:Jaymol
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 12102518
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
 
LVL 6

Author Comment

by:Jaymol
ID: 12102638
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
 
LVL 6

Author Comment

by:Jaymol
ID: 12102956
Actually, don't bother - I've just reread what you've said and that's basically what I'm already doing.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Expert Comment

by:gwalkeriq
ID: 12103880
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
 
LVL 12

Accepted Solution

by:
Ivanov_G earned 750 total points
ID: 12107553
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 12110663
Jaymol

  Did you Install MySql ODBC drivers in the computer that you testing from?
0

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question