SQLGetDiagRec, sqlstate returned?

--_000_238C17DBF4050B40991C6D06B241D7D37E1ED9FC6EABGEX73EFSC NE_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I have some problems with sqlstates returned from SQLGetDiagRec with psqlod=
bc. 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 sequ=
ence for encoding...".

Now we changed to psqlodbc 08.02.0500 and PostgreSQL 8.2.5. In the very sam=
e error situation we still see the error message as before. The sqlstate ob=
tained with SQLGetDiagRec however seems to be always "HY000" (general error=
) in more or less any error situation.

I still see the sqlstate within PostgreSQL error log, so I guess the "HY000=
" is coming from the odbc driver. Can someone give me some help with this p=
roblem? Are we missing something in our application or is this normal behav=
ior of the current driver version?

Thanks in advance and best regards,
Doris Heiser









--_000_238C17DBF4050B40991C6D06B241D7D37E1ED9FC6EABGEX73EFSC NE_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">