I have encountered the exact same error as John when linking Access
2000 tables with the following setup:
MyODBC 3.51.10-2
MySQL 4.1.8
Win XP sp2
I was able to fix the problem by installing an earlier build. Here's a
link to the file:
http://www.peterharvey.org/MySQL/MyODBC/MyODBC-3.51.10-win.msi
To be safe, you should delete the myodbc dll files in your system32
folder after uninstalling the current version and before installing
the version above.
A note to the MySql team - I could have saved a lot of time if this
revision was readily available on the MySql site.
Many great and special thanks to Peter Harvey!
Marc
---------------------------------------------------------------------------------------------------------
All,
My test platform is as follows:
MySQL ODBC 3.51.10
MySQL 4.1.7-nt
XP
I installed the driver and then from the Windows Data Source
Administrator created a system DSN entry. I hit the test button and
thought everything was great with a return of success. I then tried to
make a link from Access 2000 and received the following error from
Access.
ODBC--call failed.
[MySQL][ODBC 3.51 Driver]Could not determine the driver name so could
not lookup setup library.(#0)
Anyone have any clues? I also tried turning on the logging for odbc in
the configuration but the myodbc.log file is not anywhere on my system.
Thanks!!
John
