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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails
  • Date: Tue, 11 Sep 2018 22:42:45 +0200

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



  • Re: [freetds] SQLExecDirect() + SQLDataParam() + SQLPutData() fails, Frediano Ziglio, 09/11/2018

Archive powered by MHonArc 2.6.24.

Top of Page