[freetds] Invalid cursor state when executing 2 SELECTstatements

Sebastien FLAESCH sf at 4js.com
Mon Jan 7 11:04:46 EST 2008


Frediano,

Good news:

Just installed/compiled last snapshot and could run about 70% of my regression tests.

If you don't have ODBC tests with SQLBindParameter() using all possible data types,
I can only strongly recommend to add such test ASAP!

As a database driver interface implementer, SQL Parameter IS one of the major ODBC
features we need!

Sorry to push, I would like to contribute if I would have time.
I hope that my requests / bug reports make the project go forward.

I will check the 30% remaining and write some ODBC sample to repro if possible.

Many Thanks.
Seb

Frediano Ziglio wrote:
> Il giorno dom, 06/01/2008 alle 09.04 +0100, Sebastien FLAESCH ha
> scritto:
>> Hello Frediano,
>>
>> Frediano Ziglio wrote:
>>> Il giorno gio, 03/01/2008 alle 15.09 +0100, Sebastien FLAESCH ha
>>> scritto:
>>>> Hi all and happy new year.
>>>>
>>>> Just started to play again with the latest snapshot.
>>>>
>>>> I believe there is a problem when binding SQL_C_TYPE_TIMESTAMP + SQL_TYPE_TIMESTAMP parameters.
>>>>
>>>> Looking at the SQL Profiler output, I see that values are enclosed in duplicated quotes:
>>>>
>>>> ''2008-01-03 00:00:00.000''
>>>>
>>>> I guess it should be:
>>>>
>>>> '2008-01-03 00:00:00.000'
>>>>
>>> Quite strange... our driver should not quote anything but pass date in
>>> binary format.
>> Note it's the output of the SQL Profiler I am talking about... maybe this output is just wrong (buggy).
>>
> 
> Profiler does its best to translate RPCs to sql statements...
> 
>> I will give a try on Monday with the new FreeTDS sources.
>>
>> Maybe you better wait a bit before releasing 0.65:
>>
>> If experienced more problem with other tests but did not investigate further as the timstamp
>> problem had to be solved first to run all tests properly.
>>
> 
> Don't mind, we still do not packaged any RCs... but usually after first
> RCs 80-90% of efforts are spent on documentations, Makefiles and
> similar!
> 
>> I will spend some hours this week to check this.
>>
>> Anyway, thanks for your fast answer.
>>
>> Seb
>>
> 
> I improved genparams in order to check parameters even using cursors.
> 
> freddy77
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 



More information about the FreeTDS mailing list