Wednesday, January 19, 2011

Visual Studio 2010, Oracle 11g Client and XE 10g

Oracle's byzantine methods for configuration drive me up the wall. I struggled for 2.5 days trying to get their 11g development tools (ODT and ODP.NET) to work with Visual Studio 2010 and an already installed Oracle XE (10g).

The major issue was that the Universal Installer appeared to be loading the GAC with assemblies for version 2.112.2.0, but configured Visual Studio in the registry and machine.config files to use 4.112.2.0!

The final solution was to remove all Oracle assemblies from the GAC. After that, things started working, just needed to make sure ORACLE_HOME and PATH were configured appropriately, too. Hope that helps someone else!

No comments:

Content © didge

About Me

didge is my professional nickname, it's short for digital dave
Powered By Blogger