SQLError() not returns SQL_NO_DATA_FOUND

Asked Apr 07 '14 at 07:23

Active Apr 07 '14 at 07:40

Viewed 237 times

SQLError() is not returning SQL_NO_DATA_FOUND after driver upgrade from 7 to 9.

my code looks like

RETCODE rc = SQL_SUCCESS;
while ( rc != SQL_NO_DATA_FOUND)
{
    rc = SQLError(henv, hdbc, hstmt, sqlstate, &nativeerr, errmsg,
                 SQL_MAX_MESSAGE_LENGTH - 1, &actualmsglen);

 }

And whenever I try to access an missing table, I am getting sqlstate as 42P01 and rc as SQL_SUCCESS and it is not coming out of the loop. The same code worked fine for earlier version.

Please let me know how can I proceed further. Shall I need to handle each state separately?

edited Apr 07 '14 at 07:40

Milen A. Radev

60,241
22
105
110

asked Apr 07 '14 at 07:23

user1345697

`psql` is the commandline client for Postgres. So are you using Postgres? – Apr 07 '14 at 07:24
What libraries are you using? I don't think there's a `SQLError` function in `libpq`. – Milen A. Radev Apr 07 '14 at 07:43
We are using odbc api which will invoke postgress driver version 9.1 and not using command line client. – user1345697 Apr 07 '14 at 08:18
I am using libadpodbc library. – user1345697 Apr 09 '14 at 06:48

SQLError() not returns SQL_NO_DATA_FOUND

0 Answers0