Re: Prepared statement error with UseServerSidePrepare=1 - Mailing list pgsql-odbc

From
Subject Re: Prepared statement error with UseServerSidePrepare=1
Date
Msg-id 619ABD714EEDD84E8E582E993559DB36142AFF22@EXMB12TSTRZ2.tcad.telia.se
Whole thread Raw
In response to Re: Prepared statement error with UseServerSidePrepare=1  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
Hi,
The patches together are working. All problems I noticed in psqlodbc 9.3.3 are gone. Thank you very much.
Now, I guess, I have to test my application all over again.
When can I expect a new release of the psqlodbc driver?

Lev Bukovski

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]
Sent: 2. kesäkuuta 2014 18:17
To: Bukovski, Lev /External; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Prepared statement error with UseServerSidePrepare=1

(2014/06/02 22:11), lev.bukovski@teliasonera.com wrote:
> Hi Hiroshi,
>
> I applied your patch on psqlodbc 9.3.3 (NOT on the head branch).
> Now I can't even get to insert operations, because I get error while application configuration fetch.
>
> I have this CONFIG table, from where I load configuration parameters
> (SELECT VALUE2, VALUE3 FROM CONFIG WHERE VALUE1 = ?) Each execute of the SQL returns one row. So the first execute
success,but second returns with 'Null statement result in PGAPI_ExtendedFetch' error. 
>
> psqlodbc and mylog files are in attechaments.

Thanks for the report.
Please apply the attached patch also.

It's the same as the one attached in the thread
  [ODBC] Problems using SQLFetch on prepared INSERT with RETURNING clause .

regards,
Hiroshi Inoue



pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Installer WiX project files
Next
From: "David Joffe"
Date:
Subject: Re: Recent ODBC drivers possibly broken on XP - missing msvcrt dll