|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:
Sep. 25, 2016 03:15 AM EDT Reads: 3,320
Sep. 25, 2016 03:00 AM EDT Reads: 1,388
Sep. 25, 2016 02:45 AM EDT Reads: 845
Sep. 25, 2016 02:45 AM EDT Reads: 1,678
Sep. 25, 2016 02:15 AM EDT Reads: 1,202
Sep. 25, 2016 12:45 AM EDT Reads: 1,030
Sep. 25, 2016 12:45 AM EDT Reads: 1,927
Sep. 25, 2016 12:30 AM EDT Reads: 1,585
Sep. 24, 2016 09:45 PM EDT Reads: 1,604
Sep. 24, 2016 09:00 PM EDT Reads: 1,426
Sep. 24, 2016 08:30 PM EDT Reads: 1,443
Sep. 24, 2016 08:00 PM EDT Reads: 1,651
Sep. 24, 2016 07:00 PM EDT Reads: 2,792
Sep. 24, 2016 06:45 PM EDT Reads: 1,483
If you’re responsible for an application that depends on the data or functionality of various IoT endpoints – either sensors or devices – your brand reputation depends on the security, reliability, and compliance of its many integrated parts. If your application fails to deliver the expected business results, your customers and partners won't care if that failure stems from the code you developed or from a component that you integrated. What can you do to ensure that the endpoints work as expect...
Sep. 24, 2016 04:30 PM EDT Reads: 1,512