Re: SQLGetDiagRec, sqlstate returned? - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: SQLGetDiagRec, sqlstate returned?
Date
Msg-id 47AC9050.20109@tpf.co.jp
Whole thread Raw
In response to SQLGetDiagRec, sqlstate returned?  ("Heiser, Doris" <Doris.Heiser@fujitsu-siemens.com>)
List pgsql-odbc
Heiser, Doris wrote:
> Hi,
>
> I have some problems with sqlstates returned from SQLGetDiagRec with
> psqlodbc. We use PostgreSQL with psqlodbc on Linux systems.
>
> We do at least some checks on sqlstates returned from PostgreSQL within
> our application to implement some specific error reactions.
>
> This worked fine with psqlodbc 08.01.0200 and PostgreSQL 8.1.9. We used
> to get a specific sqlstate and error message, e.g. “22021”, “invalid
> byte sequence for encoding…”.
>
> Now we changed to psqlodbc 08.02.0500 and PostgreSQL 8.2.5. In the very
> same error situation we still see the error message as before. The
> sqlstate obtained with SQLGetDiagRec however seems to be always “HY000”
> (general error) in more or less any error situation.

I can see "22021" "invalid byte sequence ..." error message in a test
  case.

Could you send me directly the Mylog message ?

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: "Heiser, Doris"
Date:
Subject: SQLGetDiagRec, sqlstate returned?
Next
From: "Zubkovsky, Sergey"
Date:
Subject: timestamp as varchar(23)