[freetds] second query fails when querying sql server 2008
James K. Lowden
jklowden at freetds.org
Sun Feb 7 12:55:50 EST 2010
Patrick H. Burke wrote:
>
> I connect using the following scenarios:
>
> -----------------------------------------------
> Connect to isql
> Select * from sip_acc
> (55 rows returned)
> Disconnect
>
> -----------------------------------------------
>
> Connect to isql
> Select 1
> (1 row returned)
> Select * from sip_acc
> (0 rows returned)
> Disconnect
>
> NOTES: Looking in the freetds.log file I see there are
> 55 rows returned.
> token.c:2175: rows_affected = 55
I cannot reproduce this. Unless you get the same results from bsqlodbc, I
would be inclined to suspect the tool, not the library.
--jkl
More information about the FreeTDS
mailing list