Saturday, 7 September 2013

using both the 32-bit and 64-bit Oralce 12c ODP.NET Managed Driver Oracle.ManagedDataAccessDTC.dll assembly on the same machine

using both the 32-bit and 64-bit Oralce 12c ODP.NET Managed Driver
Oracle.ManagedDataAccessDTC.dll assembly on the same machine

I have a web application that is built in visual studio 2010. It uses the
ODP.NET Managed driver. It is configured to run as AnyCPU. When debugging
the application in visual studio it runs in 32-bit mode with the built in
web server. However I also need to test deployment packages on my machine
by deploying to my local IIS server. The local IIS server runs as 64-bit.
The xcopy installer will not fully install the 32-bit
Oracle.ManagedDataAccessDTC.dll on a 64-bit OS.
The Oracle documentation states:
Oracle.ManagedDataAccessDTC.dll is only needed if the application uses
distributed transactions.
For ASP.NET applications this does not seem to be true. Something in
ASP.NET is forcing a load of all assemblies, and therefore, I need to have
both the 64-bit and 32-bit versions working correctly in regards to
ASP.NET applications regardless of whether or not I'm using distributed
transactions.
I currently have visual studio set up to use IIS as the debugging
webserver. Therefore debugging works in 64-bit mode. However this is not
optimal long term. It requires all of the developers to understand
configuration of IIS, which includes:
folder permissions on project folders for correct IIS usage
application pools, its configured user, and .net version
website configuration, ports, and virutal directories as applications
I would like a less invasive approach that does not require special
configuration for every developer every time they pull a project down from
source control.

No comments:

Post a Comment