Mysql Connection

[bam720]

Mysql provider initialization failed when trying to test my MySQL Data connection under Data explorer. Does anyone have any ideas? Thanks

 

[Stretchwickster]

What version of Delphi are you using?

When you say "Data explorer", do you mean the "Database Explorer" that is accessible from within Delphi's menu system?

Have you already created an ODBC connection using the "Data Sources (ODBC)" administrator found in the "Administrative Tools" section of the Windows Control Panel?

I have an ODBC connection to a remote MySQL Server setup in the Data Sources administrator and, on opening Delphi's Database Explorer, it is automatically picked up and displayed under the Databases section of the tree-view.

Clive

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer." (Paul Ehrlich)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096

 

[bam720]

I am running Delphi 2006.

In 2006 I think its just called Data Explorer, but its the same idea as Database Explorer.

I tried just modifying the exsiting settings on the MYSQL connection.

I see the tables entry under a tree view so thats why I think we are talking about the same thing. Mine won't show my remote info though becuase of the above error I mentioned.

 

[Stretchwickster]

Have you actually set up an ODBC connection using Windows (as I mentioned above) because there's a "Test" button on the configuration dialog which allows you to test the remote connection?

Have you installed the MySQL ODBC Driver? If not, you can download it from the following page:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

Clive

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer." (Paul Ehrlich)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096

 

[ndaru]

Have you consider to use a direct connection to MySQL server using drivers other than ODBC? Direct connection is (always) better than ODBC.

The price tag for Delphi 7 Enterprise and non-Enterprise differs so much, because the former includes SQLLink to connect to MSSQLServer, while the latter can only connect to MSSQL Server using ODBC.

Try MySQL components from crlab or microolap.


--

http://www.freetechbooks.com