Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Thursday, April 03, 2014 8:23 AM
Points: 99, Visits: 2,170
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:21 PM
Points: 2,842, Visits: 2,423
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 12,206, Visits: 9,169
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 LessThanDot.

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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse