Re: ODBC Connection to External Data Source

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(at)mverify(dot)com]
Sent: Tuesday, January 27, 2004 4:56 PM
To: pgsql-odbc(at)postgresql(dot)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