freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails
- 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
-
Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails,
Sebastien FLAESCH, 10/10/2018
-
Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails,
Sebastien FLAESCH, 10/10/2018
- Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails, Frediano Ziglio, 10/10/2018
- Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails, Frediano Ziglio, 10/10/2018
-
Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails,
Sebastien FLAESCH, 10/10/2018
Archive powered by MHonArc 2.6.24.