--_4ffb0ba7-c3e7-49b4-8d17-2e03a209f920_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Good morning,

I have the following problem.


I have a Windows 2003 Server with a static IP. I've installed on this Serve=
r a web site (Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_a=
utoindex_color PHP/5.1.1 MySql 5.0.18) and I've also installed Connector My=
Sql ODBC Ver. 3.51.12.

I need to connect from a Remote HOST (with a dynamic IP) to one database in=
stalled on this Server. I tried to create a User DSN to connect to the remo=
te 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 [at] %)

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 G=
RATUITAMENTE Windows Live Toolbar!
http://toolbar.live.com=

--_4ffb0ba7-c3e7-49b4-8d17-2e03a209f920_--

Hello Luca,

Verify your my.ini file. Have you commented this line?

# localhost which is more compatible and is not less secure.
#_bind-address = 127.0.0.1_


Luca Lallone a écrit :
> 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 [at] %)
>
> 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/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

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:lalloneluca [at] hotmail.com]
Sent: Friday, 13 October 2006 10:42 PM
To: myodbc [at] lists.mysql.com
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 [at] %)

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/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

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:lalloneluca [at] hotmail.com]
> Sent: Friday, 13 October 2006 10:42 PM
> To: myodbc [at] lists.mysql.com
> 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 [at] %)
>
> 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/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Looks like a networkproblem to me.
This error seems to arise before any login.
Is the firewall on the server blocking your request on port 3306 (Did
you open the port)?

Regards,
Karsten Kaus

> [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on
> <static_ip_server_2003> (10060)


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Hi,

> 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 [at] %)

I'm confused by the above line...

What do you mean 'user [at] %'

When you set a username/password through the GRANT command, the
format is:

grant all to USERNAME [at] HOSTNAME identified by PASSWORD

The '%' is used as a wildcard to match the hostname, but it isn't a
component of the username or the password.

There's a basic walkthrough of the steps required to connect from one
machine to another (with a Unix/Linux MySQL host, although the same
principles apply to a Windows/Windows connection) here:

http://dev.mysql.com/doc/refman/5.1/en/myodbc-examples-walkt hrough.html

MC

--
Martin MC Brown, Technical Writer
MySQL AB, http://www.mysql.com
Skype: mcmcslp



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org