Solved

How to solve this problem "The 'OraOLEDB.Oracle' provider is not registered on the local machine." ?

Posted on 2008-10-06
4
3,500 Views
Last Modified: 2013-11-11
hi all,
i am using VS 2005 and i try to open an oracle database using such code:
OleDbConnection connection = new OleDbConnection(connectionString);
    ConnectionMonitor monitor = Monitor;

    if ( monitor != null )
    {
      monitor.Add( new ConnectionInfo( connection ) );
    }
    connection.Open();
---------------------------------
when i  try to run my web application, the error message pops up: The 'OraOLEDB.Oracle' provider is not registered on the local machine.
the error occurs at "connection.Open();".
i installed oracle 11g on my machine. and i try to add it in control panel > adminstrative tools > ODBC data source administrator > user DSN tab > click 'add' button > in 'create new data source' window, select 'oracle in oraodac11g_home1' > click 'finish' button > i got an error 'the setup routines for the oracle in oraodac11g_home1 ODBC driver could not be loaded due to system error code 126' > click 'ok' button > an message pops up 'could not load the setup or translator library'

how to solve this problem? i am really struggling with it.

thanks a lot
viola
0
Comment
Question by:viola123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 14

Expert Comment

by:CtrlAltDl
ID: 22655004
Check this out:
http://forums.asp.net/t/87242.aspx

The last post says he had to change the permissions on the folder where the db driver is located.
0
 
LVL 6

Author Comment

by:viola123
ID: 22655846
hi, i tried this solution but it doesn't work. and i found someone said we have to install oracle 11.1.0.7 or back to 10g.
0
 
LVL 11

Expert Comment

by:Vivek Thangaswamy
ID: 22657074
When i faced this problem I got it solved by this article
http://www.ironspeed.com/Designer/5.2.1/WebHelp/Part_VI/_OraOLEDB_Oracle_provider_is_not_registered.htm
hope this helps you too
0
 
LVL 6

Accepted Solution

by:
viola123 earned 0 total points
ID: 22674807
hi, i tried the permission setting solution. it doesn't work for me. but i solve it by installing the full version of oracle 11g not the client tool.

thanks a lot
best regards
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question