?
Solved

MySQL and ADO

Posted on 2004-09-20
6
Medium Priority
?
362 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Independent Software Vendors: 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!

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month12 days, 15 hours left to enroll

777 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