C# – Error “Unable to find the requested .Net Framework Data Provider. It may not be installed”

asp.netcoracle10gvb.netvisual-studio-2008

I am using Visual Studio 2008 and oracle database 10g.

I trying to connect to the backend like this:

Subwindow "Server explorer". Push button "Connect to database" and make next chain
Data Connection->Choose Data Source->Oracle Database->oracle Data provider for .Net->Continue->Data Source name : oraclexe->Userneme: hr password: hr -> Test connection (answer "Test connected succeeded ")->push button OK and:

"Unable to find the requested .Net Framework Data Provider. It May not be installed"

I have made changes to machine.config

<add name="Oracle Data Provider for .NET" 
invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET"
type="Oracle.DataAccess.Client.OracleClientFactory, 
Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342" />

But then to same error persists. What to do?

Best Answer

Oracle data providers are specific for an architecture. If you download a 64-bit driver you need to build your application as 64bit (or AnyCPU if the target OS is 64bit).

The problem is that Visual Studio is 32-bit, so you also need a 32bit driver installed.

Related Topic