[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