Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The OLE DB provider "OraOLEDB.Oracle" has not been registered. Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 4:55 AM
Points: 7, Visits: 18
Hello

I would like to connect oracle database to sql server 2005 and i installed oracle client and also used the following queries to create a linked server

1.sp_addlinkedserver 'AGRICULTS', 'Oracle',
'OraOLEDB.Oracle', 'BILLSTBLS'

2.sp_addlinkedsrvlogin 'AGRICULTS', false, NULL, 'user',
'password'

The linked server is created but when i try to run my query in sql server 2005 i get the following error:
The OLE DB provider "OraOLEDB.Oracle" has not been registered.

please help on this issue. Thanks.
Post #1473076
Posted Friday, July 12, 2013 8:44 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 11, 2015 3:26 AM
Points: 99, Visits: 2,255
Tried Googling it?
Post #1473078
Posted Friday, July 12, 2013 10:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 4:55 AM
Points: 7, Visits: 18
Yes i have been googled it several times but all in vain. ...thanks.
Post #1473131
Posted Sunday, July 14, 2013 9:52 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, June 20, 2016 9:37 PM
Points: 3,485, Visits: 3,002
Where did you install the Oracle client software ? For it to used as a linked server, it will need to be installed onto the Windows server that you have the SQL Server database engine installed on


Post #1473430
Posted Monday, July 15, 2013 12:57 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 3, 2016 7:09 AM
Points: 15,149, Visits: 13,037
Maybe you installed the 32-bit client while SQL Server is 64-bit?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1473479
Posted Monday, July 15, 2013 1:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 4:55 AM
Points: 7, Visits: 18


I installed the Oracle client on the same drive where SQL Server is installed.
Post #1473514
Posted Sunday, June 15, 2014 12:26 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:59 AM
Points: 1,519, Visits: 9,395
As Koen mentioned, did you install the 64-bit variant of the oracle client?
Did you reboot?
Post #1580945
Posted Friday, December 12, 2014 1:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 21, 2016 3:10 AM
Points: 1,069, Visits: 372
Hi,

To register provider you need one more oracle product instantclient-sqlplus-win-x86-64-11.2.0.1.0.zip and make some changes in register. All details are described in this article. http://nampark.wordpress.com/2011/01/20/installing-64-bit-odac-11-2-to-microsoft-sql-server-2008-r2-x64-for-replication/

Hope it helps. (I used this article to create oracle linked server to SQL 2014, Oracle version is 11)


~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Brevity is the soul of wit.
Post #1643604
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse