6 Replies Latest reply: Oct 3, 2013 2:42 AM by de4d356a-dc6b-441e-9ebe-aeff5db31b24

ODP.NET4, "The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

de4d356a-dc6b-441e-9ebe-aeff5db31b24 Sep 30, 2013 4:58 AM

Hi,

I created a VS2010 VB.NET project x86 compiled.

I use ODP.NET4 for the OracleConnection. For the first time, when I try to run my application on a Windows XP machine, I get this error:

"The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.

Stack Trace:

in Oracle.DataAccess.Client.OracleConnection.Dispose(Boolean disposing)

in System.ComponentModel.Component.Finalize()"

The machine has the Oracle Client 11g installed and also the ODP.NET4 correctly installed as the ODAC instructions say.

I never ran into this problem, my application has always worked on other machine, I tried everything i could or i read on the web but nothing worked...

Could someone help me?

Thanks

1. Re: ODP.NET4, "The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

Alex.Keh .Product.Manager-Oracle Sep 30, 2013 12:11 PM (in response to de4d356a-dc6b-441e-9ebe-aeff5db31b24)

Did you have an inner exception that returned "The provider is not compatible with the version of Oracle client"?
Like Show 0 Likes (0)

Actions
2. Re: ODP.NET4, "The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

de4d356a-dc6b-441e-9ebe-aeff5db31b24 Oct 1, 2013 3:00 AM (in response to Alex.Keh .Product.Manager-Oracle)

Hi,
thanks for the answer. Yes the Inner exception returns "The provider is not compatible with the version of Oracle client".
Could it be the Oracle Client Version? I just noticed that on that machine there is the Oracle Client version 11.1.
Like Show 0 Likes (0)

Actions
3. Re: ODP.NET4, "The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

Alex.Keh .Product.Manager-Oracle Oct 1, 2013 10:30 AM (in response to de4d356a-dc6b-441e-9ebe-aeff5db31b24)

Yes, a mismatched Oracle Client and ODP.NET version is the most likely reason for the error.

If you must have two versions of the Oracle Client on the machine, one for ODP.NET and one for another app, then use the ODP.NET DllPath setting to point Oracle.DataAccess.dll where to find the Oracle Client DLLs. Chapter 2 in the ODP.NET doc describes how to set this up.
Like Show 0 Likes (0)

Actions
4. Re: ODP.NET4, "The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

de4d356a-dc6b-441e-9ebe-aeff5db31b24 Oct 2, 2013 3:12 AM (in response to Alex.Keh .Product.Manager-Oracle)

Thank you, so you suggest me to install the Oracle Client Version 11 Release 2, is it?
Like Show 0 Likes (0)

Actions
5. Re: ODP.NET4, "The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

Alex.Keh .Product.Manager-Oracle Oct 2, 2013 1:09 PM (in response to de4d356a-dc6b-441e-9ebe-aeff5db31b24)

No. I suggest you use the DllPath setting in ODP.NET to tell Oracle.DataAccess where to find the correct version of its unmanaged DLLs.

More details here and here.
Like Show 0 Likes (0)

Actions
6. Re: ODP.NET4, "The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

de4d356a-dc6b-441e-9ebe-aeff5db31b24 Oct 3, 2013 2:42 AM (in response to Alex.Keh .Product.Manager-Oracle)

Thanks
Like Show 0 Likes (0)

Actions

Go to original post