[Devel] odbc db driver and postgresql
Henning Westerholt
henning.westerholt at 1und1.de
Tue Apr 17 11:24:54 CEST 2007
Hello,
after a somewhat lengthy debug session with Brent Thomson at last Friday on
IRC, i just want to mention that there a issues with openser-1.1 to connect
to posgresql 8.1 with postgresql-odbc 8.0.
The first connection to the db is fine, but then some version mismatch
problems occurs, and the odbc driver returns a SQL_SUCCESS_WITH_INFO code,
and the connection fails as openser go to an error condition.
This handling of SQL_SUCCESS_WITH_INFO (my_con.c, line 142) is a not optimal,
as it could signal a non fatal minor issue and also a fatal error.
He try to comment out this check, but then he get another error about
unterminated quoted strings.. After that he decide to give 1.2 a try and use
the native postgresql driver.
Have anybody been successfully used the odbc driver with postgresql? Or is
this combination not supported?
Cheers,
Henning
More information about the Devel
mailing list