Re: SQLExecDirect() + SQLDataParam() + SQLPutData() fails

Sebastien FLAESCH <[email protected]> Wed, 10 Oct 2018 12:04:35 +0200
Newsgroups gmane.comp.db.tds.freetds
Organization Four Js Development Tools
Message-ID <[email protected]>
Hello!

Regarding this fix in Branch-1_00, where can I download sources ready
for compilation?

https://github.com/FreeTDS/freetds/tree/Branch-1_00

Once compiled and installed, how can I distinguish a 1.00 installation
with and without the fix?

I see there are only major tags:

https://github.com/FreeTDS/freetds/tags

What is the policy?

"Just always keep it up to date with Branch-1_00" ?

Cheers,
Seb

On 9/11/18 10:42 PM, Frediano Ziglio wrote:
> Il giorno sab 30 giu 2018 alle ore 13:07 Sebastien FLAESCH
> <[email protected]> ha scritto:
>>
>> Attached, the code example to reproduce:
>>
>> When using SQLPrepare() + SQLExecute():
>>
>> $ gcc -D USE_PREP_EXEC -o odbctest3.bin odbctest3.c ...
>>
>> $ ./odbctest3.bin
>>   >> prepare insert...
>>   >> bind ...
>>   >> execute...
>>   >> param data...
>>   >>>>> put varchar(max)
>>   >> param data...
>>
>>
>> When using SQLExecDirect():
>>
>> $ gcc -o odbctest3.bin odbctest3.c ...
>>
>> $ ./odbctest3.bin
>>   >> bind ...
>>   >> exec direct...
>>   >> param data...
>>   >>>>> put varchar(max)
>> Error -1 at: SQLPutData 1
>> Diagnostic info:
>>     SQL State: HY010
>>     SQL code : 0
>>     Message  : [FreeTDS][SQL Server]Function sequence error
>>
>>
>> What is wrong in my ODBC function sequence?
>>
>> Cheers,
>> Seb
>>
>>
>> On 06/29/2018 03:09 PM, Sebastien FLAESCH wrote:
>>> Hi all,
>>>
>>> Just asking before sending a little code sample to reproduce:
>>>
>>> Is there a know limitation regarding VARCHAR(MAX)/VARBINARY(MAX) parameters
>>> and SQLExecDirect() + SQLParamData() + SQLPutData() ?
>>>
>>> When using SQLPrepare() + SQLExecute() + SQLParamData() + SQLPutData(), I can
>>> send Large Objects, but with SQLExecDirect(), I get the error:
>>>
>>> [FreeTDS][SQL Server]Function sequence error
>>>
>>> When doing the first SQLPutData() ...
>>>
>>> Seb
> 
> Sorry for the delay, very easy to fix. Fixed in Branch-1_00 and master.
> I'll integrate the test.
> 
> Frediano
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> https://lists.ibiblio.org/mailman/listinfo/freetds
>