Re: ODBC Connection to External Data Source
От | Goulet, Dick |
---|---|
Тема | Re: ODBC Connection to External Data Source |
Дата | |
Msg-id | 4001DEAF7DF9BD498B58B45051FBEA656D80E7@25exch1.vicorpower.vicr.com обсуждение исходный текст |
Ответ на | ODBC Connection to External Data Source ("Paul R. Sand" <paul_sand@mverify.com>) |
Список | pgsql-odbc |
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 SourceI 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 по дате отправления: