An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems using SQL.
OLE DB (Object Linking and Embedding Database, sometimes written as OLEDB or OLE-DB)allows accessing data from a variety of sources in a uniform manner.
To download ODBC drivers for PostgreSQL click here
https://www.postgresql.org/ftp/odbc/versions/msi
To watch video on Linked Server Part 1 : https://youtu.be/3hBNGnFVxP4
To download PostgreSQL click here (download the latest version) https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
Comments are closed.