Oracle OLEDb

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Chris Skaryd

    Oracle OLEDb

    Is it possible to have the Oracle OLEDB or ODAC drivers for 8i and 10g
    installed on the same machine?

    If so, is there a way to select oracle home's between 8i and 10g?

    I have an application written in VB6 against an 8.1.7 database. The
    database is being migrated to 10g on a separate server. My client would
    like to run in parallel for a few weeks entering and querying the same
    data from both servers. The application has been recompiled using the
    10g OLEDB/ODAC drivers and needs to run on the same machine as the
    application compiled against the 8i OLEDB drivers.

    I feel that I am missing something fairly basic. But the 10g ODAC
    install corrupts the 8i Client install and the old application is then
    unable to connect to the 8i database until all Oracle components are
    uninstalled and removed from the registry.

    Is there any way to make these 2 versions play nicely together?

    Thanks in advance for any help.
  • Eric Fortin

    #2
    Re: Oracle OLEDb


    "Chris Skaryd" <no@one.comwrot e in message
    news:ekpLf.1439 38$5o2.24290@fe 06.news.easynew s.com...
    Is it possible to have the Oracle OLEDB or ODAC drivers for 8i and 10g
    installed on the same machine?
    >
    If so, is there a way to select oracle home's between 8i and 10g?
    >
    I have an application written in VB6 against an 8.1.7 database. The
    database is being migrated to 10g on a separate server. My client would
    like to run in parallel for a few weeks entering and querying the same
    data from both servers. The application has been recompiled using the 10g
    OLEDB/ODAC drivers and needs to run on the same machine as the application
    compiled against the 8i OLEDB drivers.
    >
    I feel that I am missing something fairly basic. But the 10g ODAC install
    corrupts the 8i Client install and the old application is then unable to
    connect to the 8i database until all Oracle components are uninstalled and
    removed from the registry.
    >
    Is there any way to make these 2 versions play nicely together?
    >
    Thanks in advance for any help.

    What is your error when trying to connect?


    Comment

    Working...