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

SQL Server how to use Linkserver to connect Oracle, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

1. Install Oracle Client

The prerequisite for connecting to Oracle is to install Oracle Client on the SQL Server server.

After installation, you need to modify the corresponding tnsnames file to connect the corresponding data, which is located in the directory:

Oracle installation path\ product\ 10.2.0\ client_1\ NETWORK\ ADMIN

Connection string format:

QAS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.10.181) (PORT = 1527)) (CONNECT_DATA = (SERVICE_NAME = QAS)))

two。 Establish a Link Server connection

First open SQL Server Management Studio, expand to Server Objects-- > Linked Server, right-click the item and select New linked Server to enter Link Server information.

3. Use Link Server

SQL Server provides two ways to connect to Link Server:

Select * from openquery (QAS, 'select * from sapr3.mseg') select top 100 * from [QAS]. [SAPR3]. [MSEG]

Note:

1) the second method should pay attention to case 2) both methods cannot use indexes and do not support the use of large quantities of data.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.