Archive: Test wether Oracle client 9.2 is installed?


Test wether Oracle client 9.2 is installed?
Hi, how can i test if an Oracle 9.2 client is installed on a target machine? It would be sufficient if somebody could tell me the correct registry key/value

TIA
Jens


I don't know of a simple method to detect an Oracle client by analyzing the registry, because Oracle allows multiple clients to be installed (Oracle Homes), which may be switched by Oracle's Home Selector. This app modifies (among others) Window's path variable to point to the BIN-directory of the selected home.

Beside this method, there is an instant client, which needs no installation (and registration), but common to the standard installation, the path of the instant client has to be set in the PATH-variable. And every client (standard and instant) has an OCI.DLL in this path, so you have somehow to check for the existence of this file (LoadLibrary ? - should work without pathspec) and - if needed - check the version info of the DLL...