Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

freeTDS and MSSQL2000

0 views

Skip to first unread message

Alex Harsch

unread,

Jul 19, 2004, 12:31:53 PM7/19/04

Hello NG,

I am trying to set up an ODBC connection to an SQL server from my linux
client, using the freetds driver.
Using the tsql tool included in freetds, I get connect myself to the
database successfully. Using the ODBC connection gives me the following
error:
[IM002][unixODBC][Driver Manager]Data source name not found, and no default
driver specified

This is my odbc.ini file:
[tasktimer]
Description = MSSQLDriver
Driver = MSSQLDriver
Servername = sqlserver.xxx
Database = tasktimer
UID = sa
PWD = sa
Port = 1433

This is my odbcinst.ini file:
[MSSQLDriver]
Description = Treiber fr MS SQL
Driver = /usr/local/lib/libtdsodbc.so.0.0.0
Setup = /usr/lib/unixODBC/libtdsS.so.1.0.0
FileUsage = 1
CPTimeout =
CPReuse =

I compiled the driver successfully using the following configure options:
./configure --with-odbc-nodm=/usr/include/ --with-tdsver=8.0

Has anyone experienced similar problems? Any help is very appreciated.

Regards, Alex

0 new messages