CODEWITHSUNDEEP
asp.netodp.net
Josh
Josh

Reputation: 8477

ODP.NET 64 bit Server deploy, development on 32 bit OS

What is the best approach to developing a web application in Visual Studio 2010 on Windows XP 32 bit (no choice, corporate mandate) that uses the Oracle Data Provider for .NET (11.2 Release 3) but is targeting a Windows Server 2008 64 bit OS? How do programmatically switch between the 32 bit and 64 bit driver or can this be handled another way?

Update: I've created a new question about 64 bit development on 32 bit OS with an unmanaged 64bit dll reference.

Upvotes: 1

Views: 1741

Answers (2)

Chris Marisic
Chris Marisic

Reputation: 33098

Inform your company on the risks of developing on 32bit machines that are very disparate between your 64bit production environments.

You should not be developing on 32bit machines, your employer should provide you with adequate resources to do your job.

Having a development environment that is respective enough of your production system is an absolute requirement to success.

Edit: If you receive extensive pushback on this, acknowledge that the hard requirement for this is that Oracle is unable to and/or unwilling to create managed software interfaces that allow access to their database independent of the platform and that this is part of the associated costs for being an Oracle user.

Upvotes: 0

Uwe Keim
Uwe Keim

Reputation: 40736

I guess you are referring to Oracle's .NET library to access Oracle databases with the term ODP.NET, the Oracle Data Provider for .NET.

Developing since 2 years on various ASP.NET projects with an Oracle database as the backend, I can tell some of our experiences.

We tried hard to get a 64-bit version of ODP.NET working, both on the development machines (W7 64 bit) and the productive machines (W2K8R2, 64 bit).

Unfortunately, this was never stable/working. We ended with a 32-bit ODP.NET installation, switching the appropriate IIS 7.5 application pools to 32-bit mode.

Upvotes: 1

Related Questions