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
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'
ORACLE_CONNICTION_HR
ORACLE_CONNECTION_HR
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)