Request a Demo
Home   >   mailing lists

Re: Please install psqlODBC (64-bit) on MSSQL-server. - Mailing list pgsql-admin

From Roland Müller
Subject Re: Please install psqlODBC (64-bit) on MSSQL-server.
Date
Msg-id CA+8p0G0VwaTN+zD=qTOkGqA+9fdBta13qR6gfBT=OBkSzfXCHg@mail.gmail.com
Whole thread
In response to Please install psqlODBC (64-bit) on MSSQL-server.  (Pär Mattsson <par.x.mattsson@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Pär Mattsson
Date:
Subject: Please install psqlODBC (64-bit) on MSSQL-server.
Next
From: Urvish Rana
Date:
Subject: Running pg_upgrade when changing base platform from rhel 9 to 10.