FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

The easier way is to download the patched version from
http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/

The link point to git. tar.gz have no configure cause it come from
developing directory. configure script is a generated file not a
source one.

Frediano

2012/3/4 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds