System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

Question

I am developing Windows application in asp.net with C# and Oracle as database. Here initially the application's some modules were made using entity framework, so am trying to replace the entity framework code to simply call stored procedure.

So I did that the application works fine on server but when application is run on client machine then it gives below error.

I guess you have googled the error message. Anything found so far? The first two hits are already stackoverflow questions with the same title. — Tim Schmelter
– Tim Schmelter, Commented Jul 26, 2016 at 12:13
@TimSchmelter Yes I search and just found that 3 ODAC's dll need to be added which I did but no luck so far. — Akshay
– Akshay, Commented Jul 26, 2016 at 12:17
You're loading 32 bit assemly into 64 bit application or vice versa. — Husqvik
– Husqvik, Commented Jul 26, 2016 at 12:22

pringi · Accepted Answer · 2017-01-19 15:42:35Z

2

If nothing else works. Try this:

Project > properties > complie > check prefer 32 bit

This solved this for me.

edited Jan 19, 2017 at 15:42

pringi

4,8306 gold badges42 silver badges48 bronze badges

answered Jan 19, 2017 at 13:47

PSYDUCK

1161 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sami · Accepted Answer · 2016-07-26 12:30:55Z

0

Few things to check, may be one of them works:

Try NuGet packages for ODP.net. You can find them here: https://www.nuget.org/packages/odp.net.managed/
I agree with @Husqvik, check that system is attempting to load the 64 bit Oracle DLL, and can't because the application is running in 32 bit mode. Try setting your application to explicitly be 64 Bit. Alternatively, install the 32 bit ODP.Net drivers and see if those work any better.

Hope this helps, please reply either way. Thanks

answered Jul 26, 2016 at 12:30

Sami

3,8204 gold badges19 silver badges30 bronze badges

1 Comment

Akshay Over a year ago

I tried to change application platform to 64 bit and run the application but with no luck and alternatively installed the 32 bit ODAC with application platform as 32 bit but still error do not change nor it fixed.

slfan · Accepted Answer · 2019-05-12 08:42:11Z

0

Uninstall Oracle.DataAccess
Uninstall Oracle.ManagedDataAccess
Uninstall Oracle.ManagedDataAccess.EntityFramework
Reinstall all these.

This worked for me.

edited May 12, 2019 at 8:42

slfan

9,129115 gold badges69 silver badges81 bronze badges

answered May 12, 2019 at 8:23

Abdullah Khan

1,48117 silver badges17 bronze badges

Comments

icernos · Accepted Answer · 2019-09-06 19:00:53Z

C# instruction that caused the exception.

var connection = new OracleConnection(); // from Oracle.ManagedDataAccess.Client

Setup
2 Projects

Start Up (app.config)
Includes Oracle (app.config)

Oracle connection parameters such as port, SID, connection name, user/pass and hostname are extracted from 'app.config'. The startup project has its own 'app.config'.

Problem
The Oracle connection string from 'app.config' is not getting extracted. There is no connection string. It's as if app.config does not exist.

Root Cause
The 'sectionGroup' element in startup project's App.config was deleted! As I've learned, without this element the corresponding 'sectionGroup' in app.config where Oracle is was ignored which also ignores connection string.

How or who deleted 'sectionGroup' element?
I have one user setting in startup projects' property that I removed. Since there's only one, Visual Studio deletes the entire 'userSettings' element in app.config. This is alright, no problem. However, Visual Studio also deleted the 'sectionGroup' element.

SOLUTION
Write back the 'sectionGroup' element.

Collectives™ on Stack Overflow

System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related