Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select active Oracle ODBC Driver programmatically?

Ma617765acJan 15 2008 — edited Jan 17 2008
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2008
Added on Jan 15 2008
1 comment
1,930 views