public inbox for [email protected]  
help / color / mirror / Atom feed
From: [email protected] <[email protected]>
To: [email protected] <[email protected]>
Subject: SQLExecute returns empty SQLState and SQLMsg
Date: Wed, 7 Jul 2021 08:50:31 +0000
Message-ID: <OS3PR01MB6536CEF4E6BA72F95577AA3FEE1A9@OS3PR01MB6536.jpnprd01.prod.outlook.com> (raw)

Hi,

When I use BindParameter() to bind a BLOB type value and restart the PG server before SQLExecute().
The SQLExecute() returns -1 expectedly, but the SQLState and SQLMsg return empty values unexpectedly.
--------------------------------
   SQLState: 00000
   SQLMSG: (empty)
--------------------------------

[To Reproduce]
    Client                      Server
1. SQLConnect()
2. BindParameter()
3.                              restart PG
4. SQLExecute()

I also tried to bind the other types, they all return correctly.
--------------------------------
   SQLState: HY000
   SQLMSG: The connection has been lost;Error while preparing parameters
--------------------------------

I didn't find any explain about this problem in psqlodbc's document.
If this is a bug, could anyone give me some suggestions to solve or avoid this problem?

Any help would be appreciated!

Regards,
Fengzh


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: SQLExecute returns empty SQLState and SQLMsg
  In-Reply-To: <OS3PR01MB6536CEF4E6BA72F95577AA3FEE1A9@OS3PR01MB6536.jpnprd01.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox