From: | Tukaram Gaikwad <tukaramgaikwad10(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)lists(dot)postgresql(dot)org |
Subject: | pgsql-odbc SQLGetDiagRec() API issue. |
Date: | 2020-12-09 09:54:30 |
Message-ID: | CAKu4boGCoHjKTEuwjSf5J2PgnZ-GcVUAFiPVQKjTvAR3E3wCpQ@mail.gmail.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.
*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.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2020-12-09 11:58:17 | Re: pgsql-odbc SQLGetDiagRec() API issue. |
Previous Message | Tukaram Gaikwad | 2020-12-09 09:42:06 | pgsql-odbc SQLGetDiagRec() API issue |