Re: SQLGetDiagRec, sqlstate returned?

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