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

Raul Orduna rorduna at tracasa.es
Fri Apr 17 10:45:53 BST 2009

Thank you but I think is not necessary, I have one running in my installation.

The news DB was postgreSQL too but for other locations (SID). The version is the same and the driver too (in fact the driver configured in odbc.ini for the three connections is the one configured in odbcinst.ini).

Isql runs in all three. Dg4odbc only in the first (the old). I revised the config files of oracle more than twice but it seems all right...


-----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: viernes, 17 de abril de 2009 11:26
Para: Support for the unixODBC project
Asunto: Re: [unixODBC-support] Errors with integration between Oracle and PostgreSQL, changing machines

Raul Orduna wrote:

>But I don't understand. Each connection (old and news) needs a dg4odbc gateway that is virtually the same except the SID and name (file is copied and edited).
>The same operation of "copy and edit" was made over listener.ora and tnsnames.ora (tnsping runs!).
>The former connection runs fine, but the others fail. (and the ODBCINI is the same).
>I will try with Oracle... sight
>Looks to me as if whatever driver you are using is failing to find the 
>ini file, try setting ODBCINI=/path/to/odbc.ini in the oracle conmfig 
>file where the env is set.
I don't know what database that other driver is going to, so I can't say 
if it works in the same way, or uses unixODBC to read the config files.

If it helpes, I can send you a dg4odbc trace from the machine here 
running the 64 bit version of the driver and working just fine if that 
helps you push Oracle.

unixODBC-support mailing list
unixODBC-support at mailman.unixodbc.org

More information about the unixODBC-support mailing list