Hello,
I'm having some trouble getting the reference to the correct version of ODP.Net to stick when different users are sharing the same project file (in VS2008).
The question is, how are you supposed to reference Oracle.DataAccess.dll in VS2008 so that it will pick up the correct version, even on another user's PC?
My PC has 10g client + XE db + 11g Client installed (when references are set then everything works fine).
When I go to Add references in VS I only see the 10g ODP.Net dll. So I've been manually referencing the Oracle.DataAccess.dll file. The problem is that this saves the Hint Path in the project and because Oracle 11g client installs into a user directory (not sure why this changed), the path is different for every user. This means that everyone has to re-reference ODP.Net everytime the project changes.
I can get Oracle.DataAccess for Oracle 11g to appear in the Add References dialog if I add the location of the dll to the registry [HKEY_CURRENT_USER\SOFTWARE\Microsoft\.NETFramework\<version>\AssemblyFoldersEx\MyAssemblies]@="<AssemblyLocation>"). If I then select the version of Oracle.DataAccess I want it sets 'Specific Version' to True for the reference. All my other references (including 3rd party controls) have this set to False. I don't really want everyone working on the project to have to hack the registry so this isn't really a solution.
Thanks,
John.