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: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] unixODBC+FreeTDS isql query problems
  • Date: Thu, 29 Nov 2007 11:17:15 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page