Please install psqlODBC (64-bit) on MSSQL-server.

Поиск
Список
Период
Сортировка
Искать

Please install psqlODBC (64-bit) on MSSQL-server.

От:
Pär Mattsson <par.x.mattsson@gmail.com>
Дата:
Hi! Got this question!

Please install psqlODBC (64-bit), the official PostgreSQL ODBC driver for Windows.

MS SQL Server needs to run queries against a PostgreSQL database.

Does anyone know how to configure this?


Is this useful?

psqlodbc - PostgreSQL ODBC driver


Br Pär Mattsson

Re: Please install psqlODBC (64-bit) on MSSQL-server.

От:
Roland Müller <rolmur@gmail.com>
Дата:
Yes,  psqlodbc - PostgreSQL ODBC driver should be the tool needed in addition to the generic ODBC driver.

Then the first step is to configure the connection between ODBC and the PostgreSQL DB. odbc.ini file should declare the server and in case of need the driver too.

If this is OK then MS Server should be configured to use the ODBC connection with given credentials. 

About this part and more generally about MS SQL I have no knowledge. But since ODBC is AFAIK a MS-orginated technologie there should be good instructions available.

Am Mo., 21. Sept. 2026 um 15:32 Uhr schrieb Pär Mattsson <par.x.mattsson@gmail.com>:
Hi! Got this question!

Please install psqlODBC (64-bit), the official PostgreSQL ODBC driver for Windows.

MS SQL Server needs to run queries against a PostgreSQL database.

Does anyone know how to configure this?


Is this useful?

psqlodbc - PostgreSQL ODBC driver


Br Pär Mattsson

FAQ