I'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. I also have access to a remote web host with a mysql server - I can connect to *that* server via ODBC as well. 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've changed the IP address of the server on the host-only network to '192.168.56.20' and still get the same error message: 'Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Access denied for user 'ijdb'@'192.168.56.1' (using password: YES)' ...and no, the password isn't wrong. For some reason the ODBC connector isn't even trying to connect to the IP address I supply it, but the address of the local interface on that network. I've asked a variety of places, including the MySQL ODBC forum and mailing list. Those two are so dead it was a waste of time, and the other places I either get no response or ones where its obvious people just read what they wanted into the problem, not the details I actually supplied. I could *really* use some help on this... TIA, Monte -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
