Re: Problems with MySql CONNECTOR ODBC Ver. 3.51.12
Mike Harknett <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
May be that MySQL doesn't like the fact that you are logging in from a dynamic IP address. You may end up having to massage the request using server side code/script and then pass the request to the db. From memory the server wants the login defined as "IP.username" Although I'm not sure about this cheers mike Bonnett, John wrote: > 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]