[freetds] Invalid cursor state when executing 2 SELECTstatements

Frediano Ziglio freddy77 at gmail.com
Sun Jan 6 05:48:41 EST 2008


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




More information about the FreeTDS mailing list