Thread: pgsql-odbc SQLGetDiagRec() API issue.

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.