How to select active Oracle ODBC Driver programmatically?
Hi,
My application creates ODBC DSN to connect with Oracle 10g database server. I need to find out Oracle Driver installed on the system programmatically. I am trying to read KEY_<PRODUCT NUMBER> registry key and eventually searching ORACLE_HOME value. This helps me in searching Oracle Driver in ODBCINST.INI registry key. (Oracle in OraDb10g_home1)
If multiple Oracle clients are installed on the same system, multiple KEY_<PRODUCT NUMBER> registry keys and oracle drivers would be available. I am not sure which and how to select the current active oracle driver.
Oracle in OraDb10g_home1
Oracle in OraDb10g_home2
Can anybody help me out? Can I use inventory file (inventory.xml) to determince current active home directory? Reading PATH environment variable to identity active home directory would be tedious.