|By Jayaram Krishnaswamy||
|July 9, 2014 12:30 AM EDT||
•The ability to access data from outside of SQL Server.
•The ability to issue distributed queries, updates, commands, and transactions on heterogeneous
data sources across the enterprise.
•The ability to address diverse data sources similarly.
There are two ways to create Linked Servers in SQL Server 2012.
- Using SQL Server Management Studio
- Using the sp_addlinkedserver stored procedure
MSDASQL - Microsoft OLE DB Provider for ODBC
SAOLEDB.16 - SQL Anywhere OLE DB Provider 16
When you install SQL Anywhere 16 the servers can be used for both architectures.,
Of the two providers MSDASQL cannot be used as no MSDASQL is available for x64bit and attempts to use it to configure a linked server results in failure.
However if you use SAOLEDB.16 you can successfully create a linked server.
For a detailed step-by-step explanation review the following link: