I'm new to MySQL and now a problem occured:

I'm running a mysql-server on linux with a database test. No I want to 
connect to this via MyODBC from Windows and Linux clients. So I installed 
/etc/odbc.ini on the server:

[MySQLtest]
Description = MySQL fuer DB 'test' auf localhost
Driver = MySQL
Trace = No
TraceFile = /tmp/mysql_proto
Host=192.168.0.99
Port =3306
UserName =
Password =
Socket =
Database = test
Option = 1
DB = test

I'm able to connect from a Windows client via MyODBC and I can connect 
from the server itself using isql.

So I tried to connect from another Linux client using the same odbc.ini, 
but I get the following message:

root@workstation3:/home/manuel > isql -v MySQLtest dbuser
[unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[ISQL]ERROR: Could not SQLConnect
root@workstation3:/home/manuel >

It seems to try to connect to a local mysql-server, wich doesn't exist?

My /etc/odbc.ini on the other Linux client (same as on the server):

[MySQLtest]
Description = MySQL fuer DB 'test' auf localhost
Driver = MySQL
Trace = No
TraceFile = /tmp/mysql_proto
Host= 192.168.0.99
Port =
UserName =
Password =
Socket =
Database = test
Option = 1
DB = test

So how can I tell MyODBC to use 192.168.0.99 and not to use localhost?
Gruß    Manuel


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to