pgsql-odbc SQLGetDiagRec() API issue

From: Tukaram Gaikwad <Tukaram(dot)Gaikwad(at)amdocs(dot)com>
To: "pgsql-odbc(at)lists(dot)postgresql(dot)org" <pgsql-odbc(at)lists(dot)postgresql(dot)org>
Subject: pgsql-odbc SQLGetDiagRec() API issue
Date: 2020-12-09 09:42:06
Message-ID: AM0PR06MB63555EE5C3B67F53DD4E52508FCC0@AM0PR06MB6355.eurprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi team,

We killed Postgress node and called SQLExecute().
SQLExecute() function fail and return -1, to get diagnostic info I called SQLGetDiagRec()
this function but it gives me SQLState as "00000" which is SQL_SUCCESS,
in failure case which wrong.

Actually it should give NO_CONNECTION SQLState.

code snippet

long retcode = SQLExecute(this->m_OdbcStmt);

SQLCHAR messageText[SQL_MAX_MESSAGE_LENGTH + 1] = {0};
SQLCHAR state[SQL_SQLSTATE_SIZE + 1] = {0};
SQLSMALLINT textLength = SQL_MAX_MESSAGE_LENGTH + 1;

SQLSMALLINT idx = 1;
sqlgetdiagrecret = SQLGetDiagRec(SQL_HANDLE_STMT,
this->m_OdbcStmt,
idx, //record Number
state, //
&o_errorNo, //native Error Pointer
messageText, //Message Text
SQL_MAX_MESSAGE_LENGTH + 1, //buffer length
&textLength //length of message text
);

Please help us to resolve this issue.

Regards,
Tukaram Gaikwad

+91- 9637996389 (Mobile)

[amdocs-2017-brand-mark-rgb]

This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service <https://www.amdocs.com/about/email-terms-of-service>

Browse pgsql-odbc by date

  From Date Subject
Next Message Tukaram Gaikwad 2020-12-09 09:54:30 pgsql-odbc SQLGetDiagRec() API issue.
Previous Message Ingmar Koecher 2020-12-04 16:46:42 Crash on Windows Server 2019