Solved

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

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

734 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