• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

The provider attribute is not provided - ORACLE

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
developer2012
Asked:
developer2012
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
slightwv (䄆 Netminder) Commented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now