Linked server - When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?

-1 votes

2 answers

1449 views

sql-server sql-server-2017 linked-server oledb native-client

                          To configure linked server pointing to a SQL server, there are 4 possible options.

1. Server Type: SQL Server

2. Server Type: Other data source; Microsoft OLE DB Provider for SQL Server

3. Server Type: Other data source; SQL Server Native Client 11.0

4. Server Type: Other data source; Microsoft OLE DB Driver for SQL Server

In this question I want to specifically ask when is the recommended to use either of the above in terms of **a) use case**; and **b) deprecated/recommended not to be used**.

Asked by variable (3590 rep)

Oct 22, 2021, 11:30 AM
Last activity: Oct 22, 2021, 05:14 PM

Linked server - When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?

Related Questions