Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC connection from Oracle to PostgreSQL

569701Aug 26 2009 — edited Aug 27 2009

Hello All,

I need to connect from Oracle 10g to PostgreSQL.

Oracle 10.2.0.1 Standard Edition on Windows NT and PostgreSQL on another server.

I have some docs that say what to do (configuring the hsodbc etc), but 'am not sure on what all things to be installed(and where)

Where do i get the ODBC DRIVER for postgreSQL?
Is plsqlODBC(http://www.postgresql.org/ftp/odbc/versions/) the driver ?
Does oracle provide any driver (Generic ODBC driver ?, if so where do i get it from ? i have searched oracle dowload)
Do i need to install these ODBC drivers on both Oracle as well as PostgreSQL servers ?

TIA,
JJ

This post has been answered by Kgronau-Oracle on Aug 27 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2009

Added on Aug 26 2009

#heterogeneous-connectivity

3 comments

2,409 views