Postgres Pro
Downloads
Home   >   mailing lists

RE: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL - Mailing list pgsql-odbc

From Rolf Østvik
Subject RE: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL
Date
Msg-id DB7PR07MB38816F73FB441A86E389F1F5942F0@DB7PR07MB3881.eurprd07.prod.outlook.com
Whole thread Raw
In response to PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL  ("WAN, RUIWEN" <rx152u@att.com>)
List pgsql-odbc
Tree view

Database ODBC drivers is used the other way around. PostgreSQL ODBC driver is for accessing a PostgreSQL database from other applications.

 

I think foreign data wrappers is what you want. I have planned to do the same as you, but have not implemented or tested anything yet.

https://wiki.postgresql.org/wiki/Foreign_data_wrappers

 

Best regards,

Rolf Østvik

 

From: WAN, RUIWEN <rx152u@att.com>
Sent: mandag 31. august 2020 23:50
To: pgsql-odbc@postgresql.org
Subject: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL

 

To whom it will concern,

 

We are trying to access Oracle/MSSQL database from PostgreSQL, PostgreSQL ODBC Driver comes across.

 

Could we use PostgreSQL ODBC Driver to access Oracle/MSSQL database from PostgreSQL?

 

If the answer is yes, how? Could you share documents on how to access?

 

Thanks,

Ruiwen Wan

Principal Member of Tech Staff

Network Cloud & Infrastructure

 

AT&T Services, Inc

200 S LAUREL AVE BLDG A, E3-3D22, MIDDLETOWN, NJ 07748

o 732.420.0469 | m 732.299.6618 | ruiwen.xu@att.com

 

pgsql-odbc by date:

Previous
From: Clemens Ladisch
Date:
Subject: Re: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL
Next
From: Norman Henderson
Date:
Subject: Missing 32-bit package