Hi,
Recently I'm using Oracle.DataAccess.dll to connect oracle with the .NET C/S program.
My OS is Windows7 with 64-bit. I'm using Visual Studio 2012 and the database server is Oracle 11gR2.
And since I didn't install the ODP.NET, I was only put the following dll in my application's bin folder.
oci.dll
ociw32.dll
Oracle.DataAccess.dll
orannzsbb11.dll
oraocci11.dll
oraociei11.dll
oraociicus11.dll
OraOps11w.dll
The reason that I didn't install the ODP.NET is there are lots of other oracle client wihch are old version and still been using,
and I don't know if I install the ODP.NET will affect them.
I also write the following code in the application's config file.
<system.data>
<DbProviderFactories>
<remove invariant="Oracle.DataAccess.Client" />
<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=4.112.3.0, Culture=neutral,
PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>
Since I never install the ODP.NET, when I run my application to get the factory, which is
DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
It'll give the error message something like : "File or assembly name Oracle.DataAccess, or one of its dependencies not found".
So basicly is there something wrong with my config file, or should I have to install ODP.NET?
Could anyone help me with that? Thanks a lot.