Re: MySQL Connector/ODBC won't connect to internal network

Hello Monte,

On 10.01.2012 1:57, Monte Milanuk wrote:
> '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'...
If you could connect from host using command line interface, but could 
not do the same in odbc DS configuration dialog with very same 
credentials, then that is obviously a bug. However I could not recreate 
your problem - I could connect to the mysql server on a vm, and I did 
not see configuration dialog cutting last digits of IP address in the 
error message(I tried to connect to not existent host in same network).

Please also clear all options in the data source config, if you have 
any. Something like faulty initial statement or bogus ssl settings could 
affect connection process.

I would suggest you to verify everything once again, and If you continue 
to see the error, please try to connect using some basic odbc 
application. This would help identify if the bug is in the setup lib, or 
in the driver. And then file a bug report. And please attach ODBC trace 
describing error to your report.

Regards,
lawrin

> 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