Have Geek Brain

Multiple Oracle Clients

If I have multiple Oracle clients installed on a given workstation (such as Oracle 9 and Oracle 10), how do I specify which one is used by ADO? Is there a way to exchange between two clients?

I am currently using Oracle Provide - oraoledb, not Microsoft provider.

0


a source to share


3 answers


Apparently I asked the trick question ... while you can actually use multiple Oracle Homes, the Oraoledb driver does not support multiple houses. In fact, since the OraOLEDB component is COM-based, it can only be installed in one location at a time ...



+1


a source


The Microsoft provider depends on the current Oracle path (environment path). You can now change this through the Oracle Home selector, but the Microsoft vendor does not support the ability to programmatically change the path.



A source

0


a source


The first oracle home is used, which is specified in the PATH environment variable. Keep in mind that this is user-specific, and if you change it in a process, it will be local to that process.

In general, you shouldn't switch houses inside the software, although just use the latest version. If you are not targeting 8i, the 10g client can connect to 9i without issue.

0


a source






More articles:


All Articles