[unixODBC-support] problem with SQL connect on Solaris with MySQL
AndyHowell at raitechnology.com
Mon May 30 03:46:33 BST 2005
I'm having problems connecting to a MySQL server. My app is running on
Solaris, and the server on a linux box. When it tries to connect, I get
back an error:
[unixODBC][MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on
'furball' (2) (2003)
I can use isql to connect to the same server with the same credentials
just fine. That points to my code being broken. However, the same code
compiled and run on a linux box works fine. All machines are using
I watched the packets with ethereal, and I saw that right after the
MySQL server sends a "Server Greeting Protocol" message, the client app
disconnects. Doing the same with isql shows the username and password
being sent to the server.
I tried to trace through the unixODBC code, but can't trace through the
SQLCONNECT macro ( 3819 in DriverMangerSQLconnect.c ). From what I
gather, its at that point that it calls the driver code.
I tried to turn on tracing in the odbc.ini file, but nothing gets
written. Is there some magic I can invoke to get the mysql driver to
give more information? I don't know what the "(2) (2003)" at the end of
the error message mean.
More information about the unixODBC-support