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

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
LVL 6
viola123Asked:
Who is Participating?
 
viola123Connect With a Mentor Author Commented:
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
 
CtrlAltDlCommented:
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
 
viola123Author Commented:
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
 
Vivek ThangaswamyCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.