Solved

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

Posted on 2008-10-06
4
3,466 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
  • 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

770 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