Solved

The provider attribute is not provided  - ORACLE

Posted on 2014-10-03
2
222 Views
Last Modified: 2014-10-08
I had the following connection string

<add name="somename"  connectionString="Data Source=somename;
         USER ID = somename;
         PASSWORD = somename" providerName="Oracle.DataAccess.Client" />

Open in new window


After running program I got an error stating OLEDB connection needs a provider string, Then  I modified the string as

<add name="somename"  provider="OraOLEDB.Oracle" connectionString="Data Source=somename;
         USER ID = somename;
         PASSWORD = somename" providerName="Oracle.DataAccess.Client" />

Open in new window

Then got the error : The provider attribute is not allowed?

Can anyone please help me in resolving the issue?

Thanks,
D.
0
Comment
Question by:developer2012
[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
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40359829
I believe Oracle.DataAccess.Client is strictly for ODP.Net and .Net applications.

OLEDB is a different data access provider.

Which one is the application using?

Have you taken a look here:
https://www.connectionstrings.com/oracle/


If you are using ODP.Net, it typically comes with several samples that show you everything you need.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40369083
Can I ask why to "B" grade?

It appears you just closed this so you can ask a new question and avoid the new question lock.

If so,
That isn't the proper way to use the site.
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

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

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…
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 how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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

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