[freetds] unixODBC+FreeTDS isql query problems

Crompton, SY (Shirley) s.y.crompton at dl.ac.uk
Thu Nov 29 04:24:10 EST 2007


Hi

I am using unixODBC 2.2.11 and freetds-0.6.4-1.el4.rf (on RedHat linux) to access sql server 2000 on a windows machine.  I can run several simple select statements from tsql.  But when I use isql to test the connection, I can only run 1 query (the first one), 

Eg.

Select count(*) from mytable

--results from database deleted


then all subsequent SQL fails with SQLRowCount returns 0

Here are my configuration files:

# /etc/freetds.conf
[TDS]
        host = myipaddress
        port = 1433
        tds version = 8.0

# /etc/odbc.ini

[PEP]
Driver          = TDS
Description             = MSSQLSERVER
Trace           = Yes
TraceFile               = /tmp/people_mssql.log
Server          = myipaddress
Database                = Pep
Port            = 1433

#/etc/odbcinst.ini
[TDS]
Description             = FreeTDS driver
Driver          = /usr/lib/libtdsodbc.so
Setup           = /usr/lib/libtdsS.so.1
Trace           = Yes
TraceUtil               = /tmp/freetds.log
FileUsage               = 1
UsageCount              = 1

Could you please tell me where I am going wrong?  Many thanks

Shirley




More information about the FreeTDS mailing list