ODBC Connection Failed - Error Message #1130

[sallieann]

This is the first time I have used an ODBC connection and I'd be grateful for any help. I am trying to connect an Access database on a Windows 2000 machine to a MySQL database on a Linux server. I have downloaded and installed ODBC 3.51 on the Windows machine, and configured it as follows;

Windows DSN Name: test
MySQL Host (Name or IP address): 213.131.177.165
MySQL Database Name: test
User: root
Password: ******
I have selected "return matching rows".

When I try to connect from Access I get the following error message

ODBC--call failed.

[TCX][MyODBC]Host........is not allowed to connect to this MySQL server (#1130).

Why am I not connecting? Any help is greatly appreciated.

 

[kingpin2502]

Hi

I do believe there's a mysql ini file on the server that needs to be edited to allow connections from remote hosts. I can't remember the specifics of this but you should be able to get some more information on this via the MySQL forums.

Hope this gets you started

Regards,

Emmon Simbo
OpenLink Software
Universal Data Access & Virtual Database Technology Providers

http://www.openlinksw.com