ASP.NET 3.5 XP (32bit) + Oracle 11.2g deployment issue

[+chorpeac MVC]

Hello friends,

I have a situation that I am trying to figure out. I would like to ask for assistance from anyone with knowledge on this kind of typical setup.

I am used to deployments with ASP.NET and SQL, but I have never deployed with Oracle before.

Development: Win XP 32bit, ASP.NET 3.5, Visual Studios 2008 Oracle 32bit client installed.

Deploy Location: Windows 2008 64 bit, IIS7.x, .NET Framework 2/4.

A previous developer has installed the Oracle 11.2 client install on the server.

When i attempt to deploy, I am getting an error "Oracle.DataAccess.Cliebnt.OracleConnection threw an exception." and "The provider is not compatible with the version of oracle client".

So it has to be something with the 32bit -> 64 bit environment change... right?

[WAR-DOG]

you will have to set the app pool of the site, to run in 32bit mode... I guess :)

here is how you do it: http://help.webcontr...dicatedvps.aspx

[+chorpeac MVC]

Good point, did that prior.

[+LogicalApex MVC]

The error seems pretty self explanatory to me. I would check Oracle to see if the version of OPD.NET that you're using is correct.

The error isn't complaining about the bitness of your library, but the compatibility between the library and the Oracle stack installed on the machine. You need to be sure the Oracle Client installed is also compatible with the version of OPD.NET embedded with your application.

[+chorpeac MVC]

Got it, thanks. Ended up updating the oracle client installs on the server and everything started to work.