S
Stuart McGraw
I am having a problem creating Access tables linked to a
Mysql database. I get the widow to select a Data Source,
click on the (system) DSN I created (and tested ok), and
click ok. The Database Source selection window disappears,
but no window showing the Mysql tables ever appears nor
does any kind of error message (typical Microsoft.)
I can read the Mysql table using ODBC from a Python
program, so Mysql and ODBC seem to be working, looks
like Access is the one refusing to cooperate. Also, Access
seems screwed up after this, often dieing with an access
violation later on.
Any sugesstion about how to trouble shoot this? I generated
a odbc trace file, but I don't recognise anything in there as
being a blatant error.
Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
mysql-connector-odbc-3.51.12
Mysql database. I get the widow to select a Data Source,
click on the (system) DSN I created (and tested ok), and
click ok. The Database Source selection window disappears,
but no window showing the Mysql tables ever appears nor
does any kind of error message (typical Microsoft.)
I can read the Mysql table using ODBC from a Python
program, so Mysql and ODBC seem to be working, looks
like Access is the one refusing to cooperate. Also, Access
seems screwed up after this, often dieing with an access
violation later on.
Any sugesstion about how to trouble shoot this? I generated
a odbc trace file, but I don't recognise anything in there as
being a blatant error.
Windows-2000-sp2 / Access-2000-sp3 / Mysql-5.0 /
mysql-connector-odbc-3.51.12