Link to home
Create AccountLog in
Avatar of johnkan
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
ASKER CERTIFIED SOLUTION
Avatar of Umesh
Umesh
Flag of India image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of johnkan
johnkan

ASKER

Hi ushashtry

Hey, thanks for the prompt reply.

that was perfect.

I orgininally downloaded the latest stable version, but it was not this version.

thanks

john