从SQL Server到Oracle创建链接服务器时无法创建OLE DB提供程序'oraoledb.oracle'错误的实例 [英] Cannot create an instance of OLE DB provider 'oraoledb.oracle' error when creating linked servers from SQL server to oracle

问题描述

When I attempt to create a linked server to the oracle database from SQL Server Management Studio, I get the error: 



cannot create an instance of ole db provider "oraoledb.oracle" for linked server error 7303

我尝试过：

What I have tried:

EXEC master.dbo.sp_addlinkedserver @server = N'ORACLE_CONNECTION', @srvproduct=N'ORACLE', @provider=N'MSDASQL', @datasrc=N'XE', @catalog=N'hr'
 
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ORACLE_CONNECTION',@useself=N'False',@locallogin=NULL,@rmtuser=N'hr',@rmtpassword='hr'


EXEC master.dbo.sp_addlinkedserver @server = N'ORACLE_CONNICTION_HR', @srvproduct=N'Oracle', @provider=N'OraOLEDB.Oracle', @datasrc=N'XE'
 
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ORACLE_CONNICTION_HR',@useself=N'False',@locallogin=NULL,@rmtuser=N'hr',@rmtpassword='hr'

推荐答案

检查： sql server - 无法创建OLE DB提供程序的实例错误，因为Windows身份验证用户 - Stack Overflow [ ^ ]。它可能对您有所帮助。

Check this: sql server - "Cannot create an instance of OLE DB provider" error as Windows Authentication user - Stack Overflow[^]. It might be helpful to you.

这篇关于从SQL Server到Oracle创建链接服务器时无法创建OLE DB提供程序'oraoledb.oracle'错误的实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！