Detect Oracle ODBC Driver Name

From: wrldruler <filedown_at_hotmail.com>
Date: Thu, 06 Sep 2007 06:37:24 -0700
Message-ID: <1189085844.833387.154020@w3g2000hsg.googlegroups.com>

Hello,

I have an Access Front-End, with an Oracle Back-End, connecting via ODBC. I want to roll this out to maybe 500 users, so I am using RegisterDatabase to programatically add the ODBC DSN:

DBEngine.RegisterDatabase "CSD_PO_PMIS", str_Driver_Name, True, stConnect

Works fine except I have found the Oracle ODBC driver name
(str_Driver_Name variable above) is not consistent across all
machines:

(1) Some have it called "Oracle in Oraclehome1"

(2) Some have it called "Oracle in O9iHome1"

(3) Some don't have the Oracle driver installed, so I need it to use
"Microsoft ODBC for Oracle"

How can I detect if they have an Oracle ODBC driver installed, and what the name is, so I can plug it into my str_Driver_Name variable?

Thanks,

Chris Received on Thu Sep 06 2007 - 08:37:24 CDT