Re: [ODBC] Issues with OUT parameters in stored procedures - Mailing list pgsql-odbc

From Thomas Apsel
Subject Re: [ODBC] Issues with OUT parameters in stored procedures
Date
Msg-id 74AFC4E35F7D054BB70C4149AA30A66D9A8C9443@otmucxg20.opentext.net
Whole thread Raw
In response to Re: [ODBC] Issues with OUT parameters in stored procedures  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc

Hi,

 

thank you so much for the quick answer. But we need an official fix in the binary of the psqlodbc driver for our customers. Do you know by when this fix is available in the binary distributions?

 

I’m not quite familiar with PostGreSQL and I’m only managing this issue for our product. Is there a bugtracker or something like that for PostGreSQL driver and is our bug already added into such a bugtracker (to follow the status)?

 

Regards,

 

                Thomas

 

From: Inoue, Hiroshi [mailto:h-inoue@dream.email.ne.jp]
Sent: Dienstag, 21. Februar 2017 05:56
To: Thomas Apsel
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Issues with OUT parameters in stored procedures

 

Hi Thomas,

On 2017/02/20 22:11, Thomas Apsel wrote:

Hi,

 

we have here an issue that stored procedures cannot be found. This issue comes up with the newest psqlodbc version. The following information is from my colleague (he is currently not in the office) and I hope that this information is enough to verify the issue.


Thanks for the info.
I can verify the issue.


 

Would be fine if you can us a hint how to adjust the attached sample “params-out-test.c” or better you can fix the bug in the psqlodbc driver.


A workaround is to call SQLPrepare() and SQLExecute() instead of calling SQLExecDirect().
Attached is a patch to fix this issue.

regards,
Hiroshi Inoue


 

Thank you for your help.

 

Regards,

 

                Thomas Apsel

 

 

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: [ODBC] SQLGetTypeInfo tiny column sizes
Next
From: "Jack C. Wei"
Date:
Subject: [ODBC] ODBC connections go dead after a failed query?