Postgres Pro
Downloads
Home   >   mailing lists

Re: ODBC Connection to External Data Source - Mailing list pgsql-odbc

From Goulet, Dick
Subject Re: ODBC Connection to External Data Source
Date
Msg-id 4001DEAF7DF9BD498B58B45051FBEA656D80E7@25exch1.vicorpower.vicr.com
Whole thread Raw
In response to ODBC Connection to External Data Source  ("Paul R. Sand" <paul_sand@mverify.com>)
List pgsql-odbc
Tree view
Paul,
 
    I may be wrong, but I have not found a method of doing so either.  On the other hand, look at Oracle's Heterogeneous services to fond out how to connect Oracle to PostGres.  Yeah, I know it's backwards, but it may be better than nothing.
 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Paul R. Sand [mailto:paul_sand@mverify.com]
Sent: Tuesday, January 27, 2004 4:56 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] ODBC Connection to External Data Source

I am looking for procedures on how to connect postgres to an external data source (ODBC to Oracle). I then will query the external data source to write into postgres relations. I can’t find information on how to set up the ODBC connection from postgres to Oracle so I can use SQL in postgres to access data in the Oracle database. I have the Oracle ODBC drivers install and can access them with Excel. I need to also access the database from postgres. Any suggestions on where I can find information on how to make this OBDC connection?

 

Thanks!

 

Paul

pgsql-odbc by date:

Previous
From: "Paul R. Sand"
Date:
Subject: ODBC Connection to External Data Source
Next
From: Jeff Eckermann
Date:
Subject: Re: ODBC Connection to External Data Source