FreeTDS Development Group

["Bower, Wayne (Wayne)" <Wayne.Bower AT lsi.com>]

Sorry for my ignorance.  I followed the URL you provided below and it wasn't 
clear how to download the patch.  I found freetds/freetds:Branch-0_91 and 
used the Download Branch-0_91 as tar.gz link to download 
freetds-freetds-Branch-0_91.tar.gz, but this doesn't contain the typical 
configure script.  Not sure if I need to do something to generate the 
configure script or I didn't download the correct code in the first place.

I also see that the fix is in the nightly snapshot available at freetds.org, 
but I guess that isn't considered stable.  Is that what you meant by 
downloading the latest patched version?  Once again, I'm sorry for my 
ignorance.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: Saturday, March 03, 2012 5:37 PM
To: FreeTDS Development Group
Subject: Re: [freetds] [unixODBC][Driver Manager]Function sequence error 
(SQL-HY010)

Another fix is to download the latest patched version.... tomorrow,
just committed :)

Added a test too. Patch at
http://gitorious.org/freetds/freetds/commit/75525262a814c78d8a546d2f558895cad9938f2b

Frediano

2012/3/3 Bower, Wayne (Wayne) <Wayne.Bower AT lsi.com>:
> The problem appears to be restricted only to procedures with output 
> parameters.  We have not encountered the problem with any procedure that 
> only has input parameters.
>
> We can only avoid the problem by either not using 'SET NOCOUNT ON' or 
> moving 'SET NOCOUNT ON' to a later point in the procedure.  This is 
> demonstrated by the different examples in the test case.  Also note that 
> having output parameters and 'SET NOCOUNT ON' as the first statement does 
> not guarantee failure as shown with the example that begins with print 
> "\nCreate $proc with input, output, select, init SET NOCOUNT\n";
>
> Please let me know if you need more information.
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
> Sent: Saturday, March 03, 2012 3:16 PM
> To: freetds AT lists.ibiblio.org
> Subject: Re: [freetds] [unixODBC][Driver Manager]Function sequence error 
> (SQL-HY010)
>
> On Fri, 2 Mar 2012 16:43:39 -0500
> "Bower, Wayne (Wayne)" <Wayne.Bower AT lsi.com> wrote:
>
>> Essentially the issue appears to be related to using 'SET NOCOUNT ON'
>> in a stored procedure. The script creates a procedure and executes
>> it.  The cases that fail issue the message '[unixODBC][Driver Manager]
>> Function sequence error (SQL-HY010)'.  To avoid the failure I have to
>> either remove 'SET NOCOUNT ON' or move later in the procedure.  Keep
>> in mind that this is just a test case to reveal the issue.  In our
>> actual code we always start each procedure with 'SET NOCOUNT ON' and
>> do much more than shown in this test case.
>
> Is the problem restricted to procedures that pass parameters?  If not,
> does bsqldb exhibit the same symptoms?  If so, could you provide just
> the SQL?
>
> If parameters are required to provoke the problem, I would alter
> src/odbc/unittests/rpc.c to induce it.  It tried the attached patch;
> it did not alter the outcome of the test.
>
> HTH.
>
> --jkl
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds