ODBC error state S1092: postgresql through ODBC
- by mechcow
While performing an upgrade, our in-house software started to report the following strange error. It is a C++ application talking to a remote postgresql database, defined through ODBC:
ODBC error state S1092, native error 0. [unixODBC][Driver Manager]Invalid attribute/option identifier
Both the client and the server are Centos 5.4 Xen guests with the following RPMs installed:
postgresql-libs-8.1.18-2.el5_4.1
postgresql-odbc-08.01.0200-3.1
postgresql-8.1.18-2.el5_4.1
postgresql-server-8.1.18-2.el5_4.1
Its possible the schema changed as part of the upgrade, could this explain the error message? What does this error message actually indicate, and do you know any likely causes of it?