Skip to Content.
Sympa Menu

freetds - Re: [freetds] unixODBC+FreeTDS isql query problems

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Crompton, SY (Shirley)" <s.y.crompton AT dl.ac.uk>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] unixODBC+FreeTDS isql query problems
  • Date: Thu, 29 Nov 2007 09:24:10 -0000

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






Archive powered by MHonArc 2.6.24.

Top of Page