How to use the Oracle Provider for OLE DB driver to create a script for a sqlserver linked server

Editor to share with you how to use the Oracle Provider for OLE DB driver to create a sqlserver link server script, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Execute the following in the master library:

-- set up a database link server

EXEC sp_addlinkedserver

@ server = named Oraclelinkbones,-- the alias of the linked server to be created

@ srvproduct=N'Oracle',-- Product name

@ provider=N'OraOLEDB.Oracle',-- name of the OLEDB driver

@ datasrc=N'ORCLDB'-data source oracle "ora10g" network "admin" tnsnames.ora view

EXEC sp_addlinkedsrvlogin

'Oraclelink',-the name of the linked server that has been established

'false',-fixed * /

NULL,-- write a user name * / if you use this linked server for each user who logs in to SQL SERVER.

'reader',-account number (oracle)

'123456'- password

Exec sp_serveroption 'Oraclelink','rpc out','true'

Exec sp_serveroption 'Oraclelink','rpc','true'

-- these two open rpc,rpc out, which defaults to False, and can be used to change distributed transactions remotely. (if there is a distributed transaction operation must be set)

Execute the query statement against the remote end of the oracle in sqlserver:

Select * from openquery (ORACLEDB,'select * from all_users')

The above is all the contents of the article "how to create a script for a sqlserver linked server using the Oracle Provider for OLE DB driver". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!