+1  A: 

You need the oracle client driver installed for those classes to work.

There might be 3rd party connection frameworks out there that can handle Oracle, perhaps someone else might know of some specific ones.

Lasse V. Karlsen  2009-05-27 06:46:28
Note that you can also get this error on a 64 bit machine if you have only installed the 32 bit oracle client.
Klas Mellbourn  2010-04-13 12:45:25
+1  A: 

Both Oracle Data Provider for .NET (from Oracle) and .NET Framework Data Provider for Oracle (from Microsoft) require Oracle Client installed on machine.

Aleris  2009-05-27 07:05:14
A: 

You need an Oracle Client: http://www.oracle.com/technology/oramag/oracle/08-nov/o68odpnet.html

tuinstoel  2009-05-27 07:27:02

related questions

Oracle ODP.NET and double clicking hyperlink
Using a ref cursor as input type with ODP.NET
Oracle: Calling multiple procedures in a batch
What is the minimal setup required to deploy a .NET application with Oracle client 11?
Converting a string to an integer in oracle
Parse CSV (comma separated values) in Oracle
Are Oracle stored procedures faster than in line SQL for a Microsoft.NET application ?
Is ODP.NET redistributable?
ODP.NET OracleCommandBuilder.DeriveParameters for 9i
Oracle client x32 and x64 coexistence
Which Oracle Client and ODP.NET version should I install (using .NET 3.5)
Some data changes in the database. How can I trigger some C# code doing some work upon these changes?
ODP.NET Configuration in Web.config
Why doesn't ODP.NET 11 xcopy deployment work on a machine with Oracle DB 10 installed?
odp.net tracing
Is it ok to use oracle 11g client with a 10g server?
How to get value from an OracleParameter object
Does ODP.net close a ref cursor when the connection closes?
SqlDataSource and Oracle DataProvider I can't seem to be able to use the sqlDataprovider with odp.net
Is it possible to use ODP 11 xcopy deployment and not change the PATH?
Can I use ODAC 11g to access 10g
C# - ODP.NET and ora-01475 must reparse cursor to change bind variable datatype
.NET unable to connect to Oracle DB using Oracle proxy user
ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app