![]() ![]() We have created a data source, so we are not entering the provider string Provide string: If you have not configured the data source, you can specify the entire provider string.We have created an ODBC data source named pgadmin13, so specify pgadmin13 in it Data Source: Specify the data source name that you have specified in the pSQLODBC driver setting.Product Name: Specify the product name.We are using Microsoft OLEDB Provider for ODBC Driver. Provider: Specify the name of the provider.We are using ODBC driver to connect to a data source, therefore select Other Data source This name will be used by the queries to populate the data from PostgreSQL. Linked Server: Enter the desired name of the linked Server.To configure the linked server, specify the following details on the General page. Open SQL Server management studio □ Connect to SQL Server instance □ In object explorer, expand Server Objects □ Right-click on Linked Server andĪ dialog box New Linked Server opens. We will create a linked server using SQL Server management studio (SSMS). Now let us create the linked server in SQL Server 2019. Click on Save to update the changes in System DSN and close the dialog box. The output of the Test connection command is as following.Īs you can see, the connection was established successfully. We areĬonnecting to the DVDShop database so enter DVDShop in the Database textbox. Parameters, so we are changing the name of the database in the Database text box only. The dialog box named PostgreSQL Unicode ODBC Driver (pSQLODBC) Setup opens. To do that, Open Control Panel □ OpenĪdministrative tools □ Open ODBC Data Source (64 bit) □ open System DSN tab □ select pgadmin13 and click on Configure. ![]() In this article, we are going to connect to the DVDShop database, so we must change the database name in the pSQLODBC driver. The ODBC driver that points to the DemoDatabase of PostgreSQL. In the previous article, I have configured I have created a database named DVDShop on PostgreSQL 13. In this article, we will explore how we can utilize the ODBC driver to access the data of the PostgreSQL from SQL Server 2019.įor demonstration, I have installed and configured an instance of SQL Server 2019 and PostgreSQL 13 on my workstation. WeĪlso learned how we could download, install, and configure it. In my previous article named Configure ODBC drivers for PostgreSQL, we got introduced to the ODBC driver of PostgreSQL. ![]() This article explains configuring a linked server between SQL Server 2019 and PostgreSQL. ![]()
0 Comments
Leave a Reply. |