Solved

ERROR : The 'OraOLEDB.Oracle' provider is not registered on the local machine.

Posted on 2003-11-16
6
12,285 Views
Last Modified: 2007-12-19
Hi All,
        I am working with Dot Net and Oracle 9i. I have installed Oracle 9i client on my machine. I am able to work in "sqlplusw" and run queries there. But when I try to run the program code, it is giving the following error :
  The 'OraOLEDB.Oracle' provider is not registered on the local machine.

What can be the matter ? I reinstalled Oracle 9i but no use......

Kindly help.

Rgds
Inderjeet
0
Comment
Question by:isbhatia
[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
6 Comments
 

Expert Comment

by:Cavada12
ID: 9766773
Hi Inderjeet,
can you post the namespaces that you are using in your .aspx file?

Thanks.
0
 

Author Comment

by:isbhatia
ID: 9769493
Hi,
   The namespaces that I am using in my .aspx page are :

Imports System.Data
Imports System.Data.OleDb

Do I need to use some other namespace also ?

Let me tell you one of my findings. When I am trying to connect to database using VB, i am successful. But with the same connection string , I am getting error in ASp.NEt

Kindly Help

Regards
Inderjeet
0
 

Accepted Solution

by:
Cavada12 earned 50 total points
ID: 9771260
If you are using .Net I would suggest using the .NET Managed Provider for Oracle(http://www.microsoft.com/downloads/details.aspx?familyid=4f55d429-17dc-45ea-bfb3-076d1c052524&displaylang=en).  You need to download this to the server you are running your pages on, and then in the page declaration of the asp page ("<%@ Page Language="VB" %>") add this line:

CompilerOptions='/R:"C:\Program Files\Microsoft.NET\OracleClient.Net\System.Data.OracleClient.dll"'.

'Code************

'Delcare Oracle Objects
                Dim conn As New OracleConnection()
                Dim comm As New OracleCommand()
                Dim dr As OracleDataReader

'Set connection string and open conn
                    conn.ConnectionString ="Data Source=database;User Id=uid;Password=pwd;"
                    conn.Open()

'This is where your query code would go
                    comm.CommandText = "YourProcedureName"
                    comm.CommandType = CommandType.StoredProcedure

'If you have any Parameters:
comm.parameters.add(New OracleParameter("v_YourParamName", OracleType.varchar)).Value = "Value"
'Execute your command
comm.Connection = conn


'Place a <ASP:Datagrid> in a form on the page and set its datasource to dr to test
MyDataGrid.DataSource = dr
MyDataGrid.DataBind()
dr = comm.ExecuteReader()

'Always be sure to close your connection
conn.close()

I hope this help.
Let me know if your need any clarification on this.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:Cavada12
ID: 9771305
Sorry I pasted a couple of lines in the wrong order:


dr = comm.ExecuteReader()
should come before:
MyDataGrid.DataSource = dr
MyDataGrid.DataBind()


Sorry.
0
 

Expert Comment

by:pratap_surisoft
ID: 10595169
Hi isbhatia,
Iam facing the same problem and iam also using OleDb, did u solve the problem without using System.Data.OracleClient.dll which was suggested by Cavada12..?

Pratap
0
 

Expert Comment

by:bnucougar
ID: 11027812
Hi Cavada12,
I change my code with your solution
But I meet another problem that unable to load oci.dll, can you help me to deal with it.

thanks!
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Designing forms 3 44
Why "Mobile First"? 5 38
certificate error on website only in internal network 24 67
Display if field is NOT "" or NOT null 6 22
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

749 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