MySQL Connector/ODBC won't connect to internal network
Monte Milanuk <[email protected]> Mon, 9 Jan 2012 23:57:28 +0000 (UTC)
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
've got MySQL Connector/ODBC 5.1 installed on my Windows Vista laptop. I have MySQL 5.5.19 installed on the laptop, and was able to connect to it via the Windows Data Source Administrator app and the MySQL Connector/ODBC using a TCP/IP connection to 'localhost'. I could connect to the MySQL database both via the command-line client and via M$ Access and Excel. I also have Virtualbox installed with a LAMP server running on a host-only network. I can connect to the LAMP server via cmd.exe, PuTTY, Firefox, etc. I've modified the mysql configuration on the LAMP server to accept connections from other than just (its) localhost, and can connect to it across the (virtual) network via the mysql command line client. What I can't seem to do is create an ODBC connection to the mysql database on the LAMP server from the host PC. Specifically, when I type in the IP address for the LAMP server on the host-only network '192.168.56.101' and click 'Test', I get an error message that the connector couldn't establish a connection to '192.168.56.1'... I'm not sure why its dropping the last couple digits of the ip address... any ideas how to get around/over this? -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc