Re: second query fails when querying sql server 2008

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