Found 568 results.
Run every mile at Kovai MarathON to support the cause of promising young students’ education through our Kovaion Kalvi!
Linked server is Equivalent to Database link in Oracle database. Create linked Server in SQL Server 2012 to any version till SQL Server 2008 using SQL Server management studio
Linked server is Equivalent to Database link in Oracle database.
It is easy to create linked Server in SQL Server 2012 to any version till SQL Server 2008 using SQL Server management studio. Challenges are encountered while creating linked server for a DB from SQL2012 to SQL2000
While creating a Linked Server, it throws following error reason being that SQL Server 2012 does not support Native Client 11 to connect to SQL 2000.
EXEC sp_addlinkedserver @server = N’TESTLNSVR’,
@srvproduct=N’MSSQL’,
@provider=N’SQLNCLI10′,
@provstr=N’PROVIDER=SQLOLEDB;SERVER=xx.xx.xx.xx’
To rectify the above error , following steps should be followed:
Define ODBC data source using SQL native client 10 in ODBC tool in Windows server.
Once the ODBC Data source is completed ,perform the connectivity test and it should be successful.\
EXEC sp_addlinkedserver @server = N’TESTLNK_SVR’,
@srvproduct=N”,
@provider=N’MSDASQL’,
@provstr=N’DRIVER={SQL Server};SERVER=xx.xx.xx.xx;UID=test;PWD=Test123;’,
@catalog=N’DBNAME’
Server: TESTLNK_SVRis the link server name through which DB on target server is accessed.
Provider: MSDASQL is an OLEDB provider that connects to ODBC, instead of a database.
Provider string: SQL Server Is the OLE DB provider-specific connection string that identifies a unique data source.
Server in Provstr: Server name where the SQL Server 2000 instance is setup
Catalog: DBName is the database name that we are trying to access in target SQL Server instance.
Once the Linked Server is created, it can be accessed using below SQL.
SELECT * FROM OPENQUERY(TESTLNK_SVR,’SELECT * FROM TABLE’)
Author:
Mohammed Fazulullah
Kovaion Consulting-PeopleSoft Practice
Email: mohammed.fazulullah@kovaion.com
We're here to offer business solutions! Explore our services & solutions now.
Read MoreThis website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
