Re: FreeTDS and ODBC

hi james, thank you for an idea

i was experimenting with some more queries (i was doing comparison between
freetds, iodbc and unixodbc tools) and i found one which shows problems even sooner

'select count(*) from customer' returns correct result when launched from tsql
only, but returns nothing from iodbctest or isql (or qt application). in next i
will be using only iodbc because this is what i have to use in future anyway and
its lowest level which already shows any sign of problems

attached are 3 files

freetds_tsql.log - eberything worked as it should, i tried to use this log in
comparison with one i got when i used iodbctest, but they seem to differ too much

iodbc_odbctrace.log - problem can be found in stage when SQLFetchScroll was
called and it returned SQL_NO_DATA_FOUND instead of data

freetds_iodbctest.log - i don't know if i am reading this log correctly, its not
so selfexplanatory as one from iodbc, and it differs too much from log i got
when i used tsql. i don't know what's exactly is wrong, could you please help me
again?

i clearly see that even first packet sent differs, so it might be actually
problem that freedts doesn't cooperate with iodbc as it should? and as result it
sometimes works and sometimes not?









James K. Lowden wrote:
> Michal Seliga wrote:
>> i try to connect to microsoft sql 2000 database which runs on another
>> machine
>>
>> - tsql from freedts works (both using -S and configfile or using -H -p
>> directly) - iodbctest works (using DSN with ServerName)
>> - qt linked to iodbc library doesn't work  (every query returns empty
>> resultset) - connection to database using isql (unixodbc) doesn't work -
>> some queries work (for example select count(*) from sometable) , some
>> return empty resultsets (for example select textcolumn from sometable)
> 
> It sounds to me like some upper layer is dropping your data.  That could
> be because it's broken, or because it expects the ODBC driver to do
> something it's not doing, or is doing differently.  
> 
> TDSDUMP is your friend.  Make sure the data are being returned by the
> server, and watch for errors that might not be shown by the qt layer.  
> 
> HTH.
> 
> --jkl
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>