MySQL Bugs: #71306: ODBC data source connection

Bug #71306	ODBC data source connection
Submitted:	6 Jan 2014 11:29	Modified:	24 Feb 2014 21:55
Reporter:	Prashant rit	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.1	OS:	Windows (windows server 2003)
Assigned to:		CPU Architecture:	Any
Tags:	ODBC data source connection, remote server

Description:
First of all I installed mysql on my Windows machines. Then i installed mysql-connector-odbc-5.1.13-win32.msi.
I tried to create ODBC data source connection on localhost and it working fine.
Then I tried ODBC data source connection with MySQL server located on another server using local IP(Intranet IP) and it is also working properly. see the message connection successful.
Both machines are in same network(Intranet) and both are connected to internet.
Finally I tried ODBC data source connection with MySQL server located on another server using global IP address which i got from http://www.whatismyip.com/ site. And as shown in picture it is giving me error "Cannot connect to mysql server on '203.33.198.50'(10060)"

How to repeat:
I tried to create ODBC data source connection on localhost and it working fine.
Then I tried ODBC data source connection with MySQL server located on another server using local IP(Intranet IP) and it is also working properly. see the message connection successful.
Both machines are in same network(Intranet) and both are connected to internet.
Finally I tried ODBC data source connection with MySQL server located on another server using global IP address which i got from http://www.whatismyip.com/ site. And as shown in picture it is giving me error "Cannot connect to mysql server on '203.33.198.50'(10060)"

Using global ip to access a machine on local network may not be allowed by your routing systems.  Such 'backlooping' has been considered a security issue and is blocked by some routers etc.  There may be a setting in the router software/firmware, though.

Why is this 'critical' BTW (as I understand that you can use the LAN-ip)? Or is this a machine not on your local network? No matter what I believe this is an issue with your routing&gateway systems - and settings of same - and not with the ODBC connector.

Peter
(not a MySQL/Oracle person)

I want to transfer Data from MSSQL to mysql. For this purpose i wanted to lnk mysql server with mssql server.
Our mysql server is loacated at remote place and not in LAN.
I have tried on machine which is in our LOCAl area network and it is working very well.
When i tried using global IP it is not working.
Is it possible do ODBC connection with remote server using global IP.
If is What are the requirements.
Thanking You
Prashant parit

http://www.packtpub.com/article/mysql-linked-server-on-sql-server-2008
is link for how to link mysql with MSsql. and it is working very well for local machine and machin which are in same LAN.

ODBC conection using intranet IP address.bmp

Attachment: ODBC conection using intranet IP address.bmp (image/bmp, text), 1.27 MiB.

ODBC using Pblic IP.bmp

Attachment: ODBC using Pblic IP.bmp (image/bmp, text), 1.24 MiB.

Thank you for the report.

Please provide output of 

ping 203.33.198.50
tracert 203.33.198.50
telnet 203.33.198.50 3306 (or telnet 203.33.198.50 MYSQL_PORT)

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".