Using MS SQL7 's linked server first article

Source: Internet
Author: User
Tags join
Server yesterday said the use of remote SERVER, although easy to use, but only between the MSSQL
Use, what if you want to join SQL7 with SQL 6.5? or use SQL7 with Oracle or Sysbase.
What should I do then? This requires the use of the linked SERVER.

Today, let's talk about the method of using linked server between SQL7

First, add the target server's join in the Client Network Utility of the source server
Second, open Enterprise Manger, expand the security of the source server, in linked SERVERS
Right-click the new linked SERVER in the pop-up menu
Third, in the Linked Server Properties window, enter the target server name (the server name in the Client Network Utility) in the Linked server box, select SQL Server in the Server section, and in the server Options in terms of selected RPC and RPC out
Four, switch to security, according to the actual settings.
(I generally choose "THEY'll be mapped to" and enter the account number and password)
V. Click OK to complete Setup

What needs to be explained is that it is a bit different from remote server when used, and remote server can
Omitting catalog (DBO), but not omitted when using linked server, when I was trying to delay a lot of time because of this problem.

Above tested successfully between WIN98+SQL7 desktop and NT4+SP5+SQL7

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.