FreeTDS Development Group

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

Adriano Duarte wrote:
> isql -v coad user password
>   SQL> select SENHA from ura_instant where SENHA ='24772375'
> +---------+
> | SENHA   |
> +---------+
> | 24772375|
> | 24772375|
> +---------+
> SQLRowCount returns 2
> 2 rows fetched
> SQL> select SENHA from ura_instant where SENHA ='24772375'
> +------------+
> |            |
> +------------+
> +------------+
> SQLRowCount returns 0
> SQL> select SENHA from ura_instant where SENHA ='24772375'
> SQLRowCount returns -1

Bizarre. 

The first thing to do is to make sure it's not isql.  The second thing to
do is to make sure it's not the Driver Manager.  

I suggest you install the latest snapshot and run apps/bsqlodbc.  If you
get the same behavior, set TDSDUMP first and see what it says.  

I have to believe it will work fine.  Then your task will be to see which
component is causing the problem.  

HTH.  

--jkl