I need to check from a Visual Basic program the version of Oracle that is installed on the machine so i can choose between two different connection strings.
I think the Windows registry is the place to look for it and for Oracle8i i found in the key
the string value ORACLE_HOME_NAME which is "OraHome81"
and for Oracle10g i found in the key
the string value ORACLE_HOME_NAME which is "OraDb10g_home1"
However, as this application is installed on hundreds of server i want to be sure that checking those values is going to be enough for detecting the version of Oracle, i particularly feel unsure about the "OraDb10g_home1", can this differ depending on the installation and if so how can i know that indeed Oracle 10g is installed.