Hi all, I'm having a problem connecting to a remote machine through myodbc and unixodbc. For some reason, It tries to use a socket on the local machine instead of the remote one. Is there something I'm just stupid about here? The frustrating part is that I can connect throught the mysql client with "mysql -u username -p -h dbserver".
Here's my odbc.ini entry: [dsnname] Trace = Off #Tracefile= stderr Driver = /usr/lib/libmyodbc.so DSN = dsnname HOST = dbserver SERVER = dbserver PORT = 3306 Here's my error message, and how the myodbc connect goes through the command-line sql monitor "isql": #isql dnsname -v [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) [ISQL]ERROR: Could not SQLConnect
