Translation error on connection to MySQL

[Craig Gaffney]

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,

Craig.