Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-06
4
Medium Priority
?
3,656 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

782 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