Re: Access 2.0 and ODBC Connector - please help

[Arpad Nev]

I downloaded and installed that MyODBC16.zip, which also contains an old, 16 bit ODBC Mysql driver. Solved the 'old password' problem, too.

Now I can see all my odbc connections (both 16 bit and 32 bit), but Access 2.0 can't use any of them. Generates one of the following two errors
ODBC Specification Conformance Error (-7751)
ODBC Specification Conformance Error (-7761)

The only difference, that using the old, 16 bit MySQL odbc driver the error is generated after selecting the table, while the 32 bit (Connector/ODBC 3.51.19) generates immediately.

General query log when connecting with Connector/ODBC 3.51.19:
53 Connect root@localhost on test
53 Quit

connecting with 16 bit driver:
55 Connect arpi@localhost on Test
55 Query SELECT Config, nValue FROM MSysConf
55 Query show tables
55 Field List t
55 Field List t
55 Query show keys from t
55 Quit

There is nothing special with table t, it is a simple MyISAM table with one CHAR type, primary key field named A.

I'm trying to migrate from Access 2.0 program + Access 2.0 data (about 200 databases) to Access 2007 + MySQL, and it would help a lot if I could first migrate the data and then the program.

I'm using MySQL 5.0.45-community-nt-log, locally on Windows XP platform.



Edited 1 time(s). Last edit at 08/31/2007 01:20AM by Arpad Nev.