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: Yesterday @ 7:57 AM
Points: 99, Visits: 2,237
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: Thursday, December 4, 2014 7:54 PM
Points: 3,087, Visits: 2,686
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: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
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
Posted Sunday, June 15, 2014 12:26 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:21 AM
Points: 1,403, Visits: 6,894
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:50 AM
Points: 527, Visits: 253
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