Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sebastien FLAESCH <sf AT 4js.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails
  • Date: Wed, 10 Oct 2018 12:04:35 +0200

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
<sf AT 4js.com> 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
FreeTDS AT lists.ibiblio.org
https://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page