Ms SQL Server2014 link to ms SQL Server 2000 solutions and troubleshooting, server2014ms

Ms SQL Server2014 link to ms SQL Server 2000 solutions and troubleshooting, server2014ms

In development and enterprise applications, several versions of SQL Server are linked to each other. For distributed reading and storage, sp_addmediaserver must be implemented. SQL Server 2000, SQL Server 2008, SQL Server 2012, and SQL Server 2014:

However, to add a link to SQL Server 2014 in ms SQL Server 2000 on the local machine today, use the following method:
SQL Server create linked Server stored procedure example sharing http://www.bkjia.com/article/52314.htm this method is executed in SQL Server 2008, is no problem, it can add a link to SQL Server 2000, however, SQL Server 2008 and later versions, such as SQL Server 2012 or 2014, run normally. However, when you browse the link to the Server, the following exception occurs:

When the program is running, the following exceptions occur:

Go to the Internet to see if there are any related solutions. A netizen replied on an English site, saying that the version can be specified, but he did not post any code example. The following is an example of Insus. NET
SQL Server create linked Server stored procedure example sharing http://www.bkjia.com/article/52314.htm here slightly modified:

EXECUTE sp_addlinkedserver  @server='DB1',  @srvproduct = 'sqlserver',  @provider = 'MSDASQL',  @datasrc = NULL,  @location = null,  @provstr = 'DRIVER={SQL Server Native Client 10.0};SERVER=xxx.xxx.xxx.xxx;', @catalog = NULLGOEXECUTE sp_addlinkedsrvlogin@rmtsrvname='DB1',@useself='false',@rmtuser='sa',@rmtpassword='password';GO

The above implementation process is because the local machine has installed several versions of SQL Server. If your computer only installs SQL Server 2014, there is no other version. If you want to add another Server SQL Server 2000, you need to download SQL Server Native Client 10: http://msdn.microsoft.com/zh-cn/library/ms131321.aspx into the link, you can select "other version ":

Hehe solved another problem that seemed to be unsolvable.