MySQL Forums
Forum List  »  Delphi

Translation error on connection to MySQL
Posted by: Craig Gaffney
Date: May 30, 2007 05:43PM

G'Day everyone,

I am trying to connect to a MySQL server (5.0.41-community-nt) on a windows XP SP1 machine from Delphi Turbo. Both are running on the same machine. I can use the MySQL Browser tool to access the data without issue, and there are no other application or parties connected to the database when I try the following.

I created a brand new project, and placed a TSQLConnection component on the main form and configure it for the MySQL server. The config parameters are

DriverName: MYSQL
BlobSize: -1
Database: drc
ErrorResourceFile: <blank>
HostName: localhost
Password: <valid passowrd for user>
User_Name: <valid MySQL user>
Compressed: False
Encrypted: False

When I add a TSQLTable component, connect it to the TSQLConnection component and try to select a table, I get the following error message

dbExpress Error: [0x0007]: Invalid Data Translation

The TSQLConnection is active after this is attempted.

Any ideas as to what could be wrong?

Thanking you in advance for your help,


Options: ReplyQuote

Written By
Translation error on connection to MySQL
May 30, 2007 05:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.