freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements
- From: Sebastien FLAESCH <sf AT 4js.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Invalid cursor state when executing 2 SELECTstatements
- Date: Mon, 07 Jan 2008 17:04:46 +0100
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 haNote it's the output of the SQL Profiler I am talking about... maybe this
scritto:
Hi all and happy new year.Quite strange... our driver should not quote anything but pass date in
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'
binary format.
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
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Sebastien FLAESCH, 01/03/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Frediano Ziglio, 01/05/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Sebastien FLAESCH, 01/06/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Frediano Ziglio, 01/06/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Sebastien FLAESCH, 01/07/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
ZIGLIO, Frediano, VF-IT, 01/07/2008
- Re: [freetds] Invalid cursor state when executing 2 SELECTstatements, Sebastien FLAESCH, 01/07/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
ZIGLIO, Frediano, VF-IT, 01/07/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Sebastien FLAESCH, 01/07/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Frediano Ziglio, 01/06/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Sebastien FLAESCH, 01/06/2008
-
Re: [freetds] Invalid cursor state when executing 2 SELECTstatements,
Frediano Ziglio, 01/05/2008
Archive powered by MHonArc 2.6.24.