What is Linked Server ?
SelectSystem DSN
Click Add button and fill Postgresql server details.
Data Source is default value
Enter Database Name
Enter Server Name or IP of Server
Enter User Name
Enter Port
Enter Password
Click Ok button.
In General Section
Enter the Name for Linked Server.
Choose Other data source in Server Type
In Provider Choose Microsoft OLE DB Provider for ODBC Drivers
Enter Product Name :
Enter Data Source created in ODBC driver system DSN
Choose Be made using this security Context:
Enter user Name and Password for PostgreSQL server
Choose like above.
Click OK button
Open Query Window in SQL Server
Server Name : OFFICESERVER (linked server name)
Database : NewReXXXXXXXXX
Tablename : brandmaster
