FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Crompton, SY (Shirley) wrote:
> 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

ISTR similar reports that were a result of a local configuration problem,
having two copies of <something> installed.  Just to keep in mind.  

I think we'll need a TDSDUMP log of your session.  If you're concerned
about proprietary data in the log, "SELECT name FROM systypes" will do.  

ODBC also has a trace facility that might help.  

HTH.  

--jkl