Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    17

    Unanswered: Connecting to MySQL Datatbase with MyODBC

    I am trying to connect to a MySQL database on our Linux Server using MS Access on a Windows 2000 machine and MySQL MyODBC drivers.

    Each time I try to connect I get the following error:

    *****************************
    ODBC --call failed.
    [TCX][MyODBC]Host 'du-069-0221.access.clara.net' is not allowed to connect to this MySQL server (#1130)

    *****************************

    Can anyone please advise what could be wrong?

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: Connecting to MySQL Datatbase with MyODBC

    Originally posted by sametch
    I am trying to connect to a MySQL database on our Linux Server using MS Access on a Windows 2000 machine and MySQL MyODBC drivers.

    Each time I try to connect I get the following error:

    *****************************
    ODBC --call failed.
    [TCX][MyODBC]Host 'du-069-0221.access.clara.net' is not allowed to connect to this MySQL server (#1130)

    *****************************

    Can anyone please advise what could be wrong?
    Most likely the user ID you use to connect by ODBC from w2k machine doesnt have '%' in host field.

    provided that user ID you use to connect from w2k machine is qha_vn, the user table of mysql database should have a record:

    Host User Password Select_priv
    % qha_vn ... Y

    Hope this help
    qha_vn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •