Home ›
ASP.NET Forums » Data Access » Oracle » Many Oracle Client Homes

Many Oracle Client Homes

Last post 11-02-2009 4:49 AM by SSA. 1 replies.

Sort Posts:

  • Many Oracle Client Homes

    11-01-2009, 4:46 PM
    • Member
      point Member
    • TonySh
    • Member since 06-05-2008, 8:58 AM
    • Posts 1

    Dears,

    I have two oracle client installed on same server (Win 2003 server). OraClient10g_home1 and OraClient11g_home1.
    OraClient11g_home1 is the default.
    what i want is:
    1- change the default to be OraClient10g_home1
    2- then allow my asp.net application to connect to the database using OraClient11g_home1 (after applying the 1st request, which mean that OraClient11g_home1 is not the default client)

    In other words:
    how I can change the OracleConnection in ASP.net to use specific OracleClient without changing the default client in the registry.

    Because i have two ASP.net applications hosted on the same server. each one should connect to the database using different OracleClient
    one of them should use OraClient10g_home1 because it's connecting to Oracle8i (which is not supported using OraClient11g_home1)
    and the other one should use OraClient11g_home1 because it's using ODAC11

    Thanks,,,

  • Re: Many Oracle Client Homes

    11-02-2009, 4:49 AM
    • Contributor
      2,520 point Contributor
    • SSA
    • Member since 05-07-2009, 3:16 PM
    • Amsterdam, The Nederlands
    • Posts 419

    Hi Tony,

    Have a look at this thread,

    http://forums.asp.net/t/1414029.aspx

    How about using this idea from above thread posts,

    Environment.SetEnvironmentVariable("Path", string.format("{0};{1}",OracleHomeString, Environment.GetEnvironmentVariable("Path").ToString))
Page 1 of 1 (2 items)
RSS Available

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.