[unixODBC-support] Errors with integration between Oracle and PostgreSQL

Raul Orduna rorduna at tracasa.es
Wed Apr 8 09:56:39 BST 2009

First of all, thank you again.

Your solution obtains a successful connection from Oracle Warehouse Builder. Good!!!

The next error arises when we try to select the source tables for the project. I would remember that it seems that the text fields of pg_catalog load incorrectly (even from sqlplus, for example for 
select * from "pg_catalog"."pg_user"@postgres;

I send the logs of the select statement from unixODBC log and from dg4odbc log: 
select * from ALL_USERS at postgres;


-----Mensaje original-----
De: unixodbc-support-bounces at mailman.unixodbc.org [mailto:unixodbc-support-bounces at mailman.unixodbc.org] En nombre de Nick Gorham
Enviado el: martes, 07 de abril de 2009 17:02
Para: Support for the unixODBC project
Asunto: Re: [unixODBC-support] Errors with integration between Oracle and PostgreSQL

>The response of Oracle is included below: 
>After researching this with several engineers on the gateways team, it was determined that your ODBC driver is returning an incorrect sqlstate of "HY000" in your dg4odbc trace (allusers_dg4odbc[1].log). The correct sqlstate for an "object not found" error is "42S02". This is what's architected in the ODBC spec, drivers are supposed to follow the spec and those that don't are broken. You will need to persue this with your ODBC driver vendor.

More information about the unixODBC-support mailing list