Re: Detect Oracle ODBC Driver Name

On Sep 6, 9:37 am, wrldruler <filed..._at_hotmail.com> wrote:
> 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

I usually install the Oracle client home as Ora9i so I think you might want to read the registry for the value of Oracle_Home and work with it. You may also have to contend with multiple Oracle homes.

HTH -- Mark D Powell -- Received on Thu Sep 06 2007 - 08:57:31 CDT