Shulou(Shulou.com)05/31 Report--

SQLSERVER how to create DBLINK to operate remote server database, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

The details are as follows:

-- configure DBLINKexec sp_addlinkedserver @ server='WAS_SMS',@srvproduct='',@provider='SQLOLEDB',@datasrc='10.131.20.100'exec sp_addlinkedsrvlogin 'WAS_SMS','false', NULL,'CustomSMS','SqlGdn@InfoxMas2008'select top 100 * from AS400.AS400_Extract.DBO.ORDUNA-- of SQLSERVER database to configure DBLINKexec sp_addlinkedserver @ server=' mysqltest', @ srvproduct='mysql',@provider =' msdasql' of SQLSERVER to MYSQL database @ datasrc = 'MY_TOMATO'exec sp_addlinkedsrvlogin @ rmtsrvname='mysqltest',@useself=false,@locallogin=' local database login user', @ rmtuser='MYSQL user name', @ rmtpassword='MYSQL user password 'select * from openquery (mysqltest,'select * from marketing_data')-the MY_TOMATO here is the ODBC configured in the WINDSOWS system console and added in SYSTEM DNS! After reading the above, have you mastered how to create DBLINK and operate remote server database in SQLSERVER? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.