I am creating a script that retrieves data from a local oracle db. As of now I have the oracle data provider for .net installed. However, this is a big file and a long installation process. Is there a way to deploy a software that utilizes the System.Data.OracleClient without having to install the data provider?
+3
A:
Instant Client is the answer... see this Question for the answer. I can only vouch for it working with ODP.Net though.
jle
2009-08-10 02:50:37
I have used the Instant Client with just plain vanilla ADO.NET and the included Oracle driver in .NET 1.1 and later. In fact, we use it on a production server here for a very small ASP.NET web services site. Just remember to add the directory that contains the Oracle DLLs to your PATH environment variable.
Goyuix
2009-08-12 14:11:33
Instant Client is still a large install
Ian Ringrose
2010-09-21 15:33:19
A:
thanks for the reply! i have tried oci however i can't seem to load the assembly.
What do you mean load the assembly? You pretty much just need to copy all of the .dlls required for Oracle Instant Client into the directory and then set them to copy always. The only dll you need to use it the OracleClient... that being said, have you looked at using ODP.Net?
jle
2009-08-10 13:14:12
@jle: I believe ODP.Net still has a dependency on the native DLL being present, either from the instant client of a full install.
Goyuix
2009-08-12 14:12:29