Windows 7 64 system, Delphi7.0, MySQL 5.7, MySQLODBC driver version is 5.1

After install the ODBC driver in Windows system has established the system DSN ODBC connection, test the connection is successful,
In Delphi through ADO graphical interface connection, can't find just set up an ODBC connection, back to the Windows ODBC, will set up to the user DSN ODBC, Delphi ADO in can see the ODBC connection, but the test connection is successful, the prompt "in the designated DSN, driver and application architecture does not match between",

By configuring ADO connection string to connect:
DM. Ac. The ConnectionString:=
'the Driver={MySQL ODBC Driver 5.1}; Server=192.168.1.16; The Database=testdb; User=root; Password=root; Option=3; ';
DM. Ac. Close;
DM. Ac. The Open;

Execution times wrong "and did not find the data source name not specified the default driver".

CodePudding user response:

Try to install 32-bit drivers or client

CodePudding user response:

Search for the control, ZEOSDBO connect to the database

CodePudding user response:

64 - bit systems need to be performed under the Windows \ SysWow64 \ path under odbcad32 exe remember!!!!!

CodePudding user response:

Windows 7 64 - bit, D7 only supports 32 bit, so the ODBC can only use the 32-bit,

Of course to use 32-bit odbcad32. Exe,