Jump to content



Photo

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

asp.net iis7 oracle deployment windows server 2008

  • Please log in to reply
4 replies to this topic

#1 +chorpeac

chorpeac

    NeoRequest Engineer

  • Joined: 21-March 02
  • Location: Northern Virginia
  • OS: Windows, Windows RT, Windows Phone, & iOS

Posted 10 October 2012 - 16:19

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?


#2 WAR-DOG

WAR-DOG

    join me, I have cookies

  • Joined: 19-September 06
  • Location: Slovenia

Posted 10 October 2012 - 16:28

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

#3 OP +chorpeac

chorpeac

    NeoRequest Engineer

  • Joined: 21-March 02
  • Location: Northern Virginia
  • OS: Windows, Windows RT, Windows Phone, & iOS

Posted 10 October 2012 - 16:30

Good point, did that prior.

#4 +LogicalApex

LogicalApex

    Software Engineer

  • Tech Issues Solved: 5
  • Joined: 14-August 02
  • Location: Philadelphia, PA
  • OS: Windows 7 Ultimate x64
  • Phone: Nexus 5

Posted 10 October 2012 - 16:42

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.

#5 OP +chorpeac

chorpeac

    NeoRequest Engineer

  • Joined: 21-March 02
  • Location: Northern Virginia
  • OS: Windows, Windows RT, Windows Phone, & iOS

Posted 10 October 2012 - 18:20

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



Click here to login or here to register to remove this ad, it's free!