ASP.Net migration: Exception raised

Hi experts,

I'm migrating a ASP.NET application from an IIS6 to IIS7.

The application is using ODP.Net 32 bits, and is targetted to .Net Framework 4.0

When I'm tryin to load a page I get this exception:

[A]Oracle.DataAccess.Client.OracleCommand cannot be cast to Oracle.DataAccess.Client.OracleCommand.

Type A originates from 'Oracle.DataAccess, Version=4.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342' in the context 'Default' at location 'C:\Windows\Microsoft.Net\assembly\GAC_32\Oracle.DataAccess\v4.0_4.112.1.2__89b483f429c47342\Oracle.DataAccess.dll'.

Type B originates from 'Oracle.DataAccess, Version=2.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342' in the context 'Default' at location 'C:\Windows\assembly\GAC_32\Oracle.DataAccess\2.112.1.2__89b483f429c47342\Oracle.DataAccess.dll'

Any help about the origin and solution for this error will be apprecied.

Thanks in advance.
david-martiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

esolveSoftware Development ManagerCommented:
The provider System.Data.OracleClient is a Oracle client provided by Microsoft within the .NET framework. Since this provider is deprecated, it is recommended to use the Oracle.DataAccess.Client which is provided by Oracle.

http://blogs.msdn.com/b/adonet/archive/2009/06/15/system-data-oracleclient-update.aspx
http://adtmag.com/articles/2009/06/16/microsoft-kills-oracle-data-provider-for-adonet.aspx

Looks like you need to install ODP.net
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

http://www.oracle.com/technetwork/topics/dotnet/code-154692.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.