provider is not compatible error in asp.net c#

Question

0.00/5 (No votes)

See more:

I am using ODP.NET .I have oracle database.I have installed oracle client.Added refrence of Oracle.DataAccess in visual studio 2012 and use two name spaces

using Oracle.DataAccess.Types;
using Oracle.DataAccess.Client;
and using following connection string in web.config

<connectionstrings>
<add name="Oracleconnect" connectionstring="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.234.9.4)));User ID=hr;password=hr">
providerName="Oracle.DataAccess.Client" >

but when I run my application i get following error
System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---> Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client at Oracle.DataAccess.Client.OracleInit.Initialize() at Oracle.DataAccess.Client.OracleConnection..cctor() --- End of inner exception stack trace --- at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString) at SchoolsManagementSystem.DAL.GetConnection() in d:\c#\SchoolsManagementSystem\SchoolsManagementSystem\App_Code\DAL.cs:line 20 at SchoolsManagementSystem.DAL.AunthicateUser(String username, String password) in d:\c#\SchoolsManagementSystem\SchoolsManagementSystem\App_Code\DAL.cs:line 24 at SchoolsManagementSystem.Login.btnLogin_Click(Object sender, EventArgs e) in d:\c#\SchoolsManagementSystem\SchoolsManagementSystem\Login.aspx.cs:line 46

Posted 28-Jun-14 9:04am

Sheikh Waqas Ali

Updated 28-Jun-14 9:08am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kareem Abou Saad · Answer 1 · 2014-06-28T09:40:00

Solution 1

Try to put all your DLLs in the same folder of your C# Executable.
These may include:
oci.dll
Oracle.DataAccess.dll
oraociicus11.dll
OraOps11w.dll
orannzsbb11.dll
oraocci11.dll
ociw32.dll

Check this[^] useful link for more information.

Posted 28-Jun-14 9:40am

Kareem Abou Saad

Comments

Sheikh Waqas Ali 28-Jun-14 16:31pm

I have installed ODP.NET thruogh ODAC112040Xcopy_32bit and then click install.bat and configure.bat and then added following refrence of Oracle.DataAcess.dll in Visual studio
D:\tutorials\oracle\ODAC112040Xcopy_32bit\odp.net4\odp.net\bin\4 Oracle.DataAccess.dll

I also installed oracle client runtime

D:\app\hp\product\11.2.0\client_1\ODP.NET\bin\2.x Oracle.DataAccess
and in it also have Oracle.DataAcess which refrence I used in oracle client

Sheikh Waqas Ali 28-Jun-14 16:32pm

Oracle.DataAccess.dll
oraociicus11.dll
OraOps11w.dll
orannzsbb11.dll
oraocci11.dll
ociw32.dll

where is the location of above DLLs and guide me about c# Execute able folder