The provider attribute is not provided  - ORACLE

Posted on 2014-10-03
Medium Priority
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?

Question by:developer2012
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
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 1500 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:

If you are using ODP.Net, it typically comes with several samples that show you everything you need.
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.

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
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 information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

719 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