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.
PostgreSQL running vesion on env: psql (PostgreSQL) 12.1
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.