johnkan
asked on
Error message 'HY000 user cancelled' when trying to retrieve tables from MySQL database.
Hi
I am setting up a WinXP PC with the MySQL odbc driver to connect using MS Access to my MySQL database.
It is hosted on a Linux server at present.
I can connect successfully, at least when I use the test facility on the odbc driver confguration page, but I get an HY000 user cancelled error when I actually try to link to any of the tables in it.
Any suggestions ?
Thanks in advance
john
I am setting up a WinXP PC with the MySQL odbc driver to connect using MS Access to my MySQL database.
It is hosted on a Linux server at present.
I can connect successfully, at least when I use the test facility on the odbc driver confguration page, but I get an HY000 user cancelled error when I actually try to link to any of the tables in it.
Any suggestions ?
Thanks in advance
john
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Hey, thanks for the prompt reply.
that was perfect.
I orgininally downloaded the latest stable version, but it was not this version.
thanks
john