Click here to Skip to main content
15,867,973 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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'
Posted
Updated 16-May-17 8:19am
v2
Comments
CHill60 16-May-17 6:45am    
It might be because you've used ORACLE_CONNICTION_HR instead of ORACLE_CONNECTION_HR
Richard Deeming 16-May-17 8:58am    
Have you installed the Oracle Provider for OLE DB on the SQL server?
Adam_adam 17-May-17 3:14am    
I installed the Oracle Provider for OLE DB on the SQL server.

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900