pgsql-odbc SQLGetDiagRec() API issue.

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.

Responses

Browse pgsql-odbc by date

  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