Error message 'HY000 user cancelled' when trying to retrieve tables from MySQL database.

Posted on 2006-03-21
Last Modified: 2012-06-21

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

Question by:johnkan
    LVL 26

    Accepted Solution


    Author Comment

    Hi ushashtry

    Hey, thanks for the prompt reply.

    that was perfect.

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



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now