RE: Problems with MySql CONNECTOR ODBC Ver. 3.51.12
"Bonnett, John" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Looks like it might be a MySQL permissions problem. When making the remote connection via ODBC, does the user that you are connecting have permission to connect to MySQL from that remote IP address? MySQL permissions can require the user name, password AND the remote IP address to be correct. You may need an appropriate GRANT statement. See section 5.8.2 in the MySQL manual. John Bonnett -----Original Message----- From: Luca Lallone [mailto:[email protected]] Sent: Friday, 13 October 2006 10:42 PM To: [email protected] Subject: Problems with MySql CONNECTOR ODBC Ver. 3.51.12 Good morning, I have the following problem. I have a Windows 2003 Server with a static IP. I've installed on this Server a web site (Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/5.1.1 MySql 5.0.18) and I've also installed Connector MySql ODBC Ver. 3.51.12. I need to connect from a Remote HOST (with a dynamic IP) to one database installed on this Server. I tried to create a User DSN to connect to the remote database with Connector MySql (from ODBC Manager of Windows XP Pro), but the ODBC Manager gives me the following error: REQUEST RETURN WITH SQL_ERROR and in the Diagnostic dialog, it returns the following error: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on <static_ip_server_2003> (10060) User ID and Password are correct (user@%) Static IP is also correct. I can't find a solution. Any advices? Thanks! Luca _________________________________________________________________ Cerca in qualsiasi pagina Web con una protezione efficace. Scarica subito GRATUITAMENTE Windows Live Toolbar! http://toolbar.live.com -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]