Skip to Content.
Sympa Menu

freetds - [freetds] ODBC-only connection to SQL Server from FreeBSD

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Carlo Andreoli" <vespito AT vespito.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] ODBC-only connection to SQL Server from FreeBSD
  • Date: Thu, 4 Aug 2005 15:05:28 +0200

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"
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
Port = 1433
ServerType = SQL Server 2000
Trace = yes
TDS_Version = 8.0
UID = user
PWD = psw
Database = SYSMA4
ReadOnly = no

[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.





Archive powered by MHonArc 2.6.24.

Top of Page