|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:
- Where Are RIA Technologies Headed in 2008?
- PowerBuilder History - How Did It Evolve?
- Creation and Consumption of Web Services with PowerBuilder
- Cloud People: A Who's Who of Cloud Computing
- DDDW Tips and Tricks
- Working with SOA & Web Services in PowerBuilder
- Cloud Expo 2011 East To Attract 10,000 Delegates and 200 Exhibitors
- Dynamically Creating DataWindow Objects
- OLE - Extending the Capabilities of PowerBuilder
- DataWindow.NET How To: Data Entry Form