Mysql – odbc connection from windows machine to thesql server running on ubuntu

connectivityMySQLodbcUbuntu

I was able to install mysql server on an ubuntu machine and set up a test data base, created a user and granted that user access to the database.
I also changed the binding address to the IP of the server and opened up port 3306.

I am also able to access the mysql database from another remote linux machine using the mysql client.

My question is, is it possible to access the mysql server from a windows machine using the odbc data source administrator with SQL server native client 10.0? is it even possible to do this?

Best Answer

It isn't possible as SQL Server Native Client is a client library for SQL Server, not for MySQL. If you want to access a MySQL server through ODBC, then you need the MySQL ODBC driver (Connector/ODBC).

Related Solutions

Mysql – How to connect to a network MySQL server using ODBC

Is FOO a DSN or a server name? on workbench you need the server name, mysql username and the mysql password. Thats all you need to connect to your mysql server using mysql workbench.

MySQL remote connection: Public vs. private IP address

The explanation here is a straightforward one: You can't bind a listening socket to an IP address that your machine's IP stack isn't aware of.

In AWS (whether EC2 Classic or EC2/VPC) as in many network environments these days, your external IP is not configured in your machine -- it's mapped through an external device (router, firewall) to your machine's private IP via NAT (network address translation).

You can confirm that your server itself has no idea about the external IP:

 $ ifconfig

The simplest solution, of course, is binding to 0.0.0.0 unless you have a specific reason not to.

http://en.m.wikipedia.org/wiki/Network_address_translation

Best Answer

Related Solutions

Mysql – How to connect to a network MySQL server using ODBC

MySQL remote connection: Public vs. private IP address

Related Question