FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il sab, 2002-12-21 alle 03:06, Thuy Tran ha scritto:
> I am using freetds-0.60, unixODBC-2.2.3 on Red Hat Linux release 6.2,
> connecting to MS SQLServer 2000.  I can connect to the database server
> using freeTDS tsql tool so I think my FreeTDS configuration is probably
> correct.  When I try to connect using unixODBC isql tool, I get this error:
> [unixODBC]tds_connect failed
> [ISQL]ERROR: Could not SQLConnect
> 
> and in the freetds log, I see the following msg:
> 
> Starting log file with debug level 99.
> 2002-12-20 17:54:32.595695 IP address pointer is NULL
> 2002-12-20 17:54:32.595976 Server FreeTDS not found!
> 
> Here are my ENVs
> FREETDSCONF=/u/thuytran/freetds.conf
> SYBASE=/u/thuytran/freetds
> ODBCSYSINI=/u/thuytran/odbc
> ODBCINI=/u/thuytran/odbc/odbc.ini
> ODBCHOME=/u/thuytran/unixODBC
> LD_LIBRARY_PATH=/u/thuytran/freetds/lib
> DSQUERY=FreeTDS
> TDSDUMPCONFIG=/u/thuytran/tds.log
> 
> The $ODBCINI file looks like this:
> 
> [ODBC Data Sources]
> FreeTDS         = GRS database connected thru FreeTDS
> 
> [FreeTDS]
> Driver          = FreeTDS
> Description     = GRS database connected thru FreeTDS
> Trace           = Yes
> Servername      = 128.252.144.174
> Server          = 128.252.144.174
> Port            = 1433
> UID             = username
> Database        = ody_grs
> 

Are you using CVS version, 0.60 or a recent snapshot? 

You can't use both servername and server...
If you want to use freetds.conf use servername with correct freetds.conf
server (in this case FreeTDS), if you don't want to use freetds.conf use
server (and perhaps add TDS_Version entry)

> The odbcinst.ini looks like this:
> [FreeTDS]
> Description             = FreeTDS Driver
> Driver          = /u/thuytran/freetds/lib/libtdsodbc.so
> Setup           = /u/thuytran/freetds/lib/libtdsS.so
> FileUsage               = 1
> 
> The freetds.conf looks like this:
> [FreeTDS]
>         host = 128.252.144.174
>         port = 1433
>         tds version = 7.0
> 
> Could someone help me?
> 
> Thanks.

freddy77