FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Hello,
>   I don't have root access to my server, so I installed 
> FreeTDS in my home directory. I tried it several times, 
> because I didn't manage to install libtdsodbc.so. Finally I 
> managed to do it, putting --with-iodbc=/usr/local/  .
> Now tsql connects fine:
> 
> carlo@qs41% ./tsql -H ip.ip.ip.ip -p 1433 -U user -P psw
> locale is "C"
> locale charset is "US-ASCII"
> 1>quit
> carlo@qs41%
> 
> 
> However, sometimes the connection is refused.
> 
> Anyway, the point is that iodbc does not connect:
> 
> carlo@qs41% /usr/local/bin/iodbc-odbctest "DSN= SCAM; 
> UID=user; P= psw"

Try to remove spaces.

> iODBC Demonstration program
> This program shows an interactive SQL processor
> [FreeTDS][SQL Server]Unable to connect to data source, SQLSTATE=08001
> 
> Have a nice day.carlo@qs414%
> 
> So, it looks like the problem was in the .odbc.ini. Here it is:
> 
> [ODBC Data Sources]
> SCAM= SQL Server 2000
> 
> 
> [SCAM]
> Driver          = /usr/home/carlo/freetds/lib/libtdsodbc.so
> Description     = SQL SERVER
> Server          = ip.ip.ip.ip
> Address         = ip.ip.ip.ip
> Host            = ip.ip.ip.ip

Server is sufficient

> Port            = 1433

> ServerType      = SQL Server 2000
> Trace           = yes

??? iODBC setting ??

> TDS_Version     = 8.0

ok

> UID             = user
> PWD             = psw

RTFM

> Database        = SYSMA4

> ReadOnly        = no

??? iODBC ???

> 
> [Default]
> 
> Driver = /usr/home/carlo/freetds/lib/libtdsodbc.so
> 
> Could anybody point me to my error? Thank you in advance for 
> any help. Regards;
> 
> 
> Carlo.
> 

Try removing additional settings and enabling FreeTDS logging (see
manual at http://www.freetds.org/userguide/logging.htm)

ciao
  freddy