Solved

MySQL and ADO

Posted on 2004-09-20
6
359 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
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!

 
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 250 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

697 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