[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