myodbc on remote machines?

[Michael Smith <msmith4@gladstone.uoregon.edu>]

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