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!

ODBC Driver name: {Oracle in OraHome/81/90/91/etc} - how in DSN-less connect string?

350450Oct 6 2002

I'm changing a VB application which uses the MS Oracle ODBC driver (from MDAC 2.7) to use Oracle's own 8i/9i drivers.

We don't (can't) use DSNs - we build DSN-less connection strings (built on the fly at run-time) to connect.

The question I have is this: unlike the MS driver, the Oracle driver name seems to change depending on the oracle home. For example, I have installed 9i and I have a driver in the ODBC control panel called {Oracle In OraHome90} as the driver name, but I suspect people who have 8.1.6 or 8.1.7 or later versions of 9i will see a different name.

Our application doesn't know (or care) what version of Oracle is being connected to. So how am I supposed to construct at connection string if I don't know which driver is being used?

Can I search the registry and pick up a value (I realise the client may have various oracle clients installed) to use in my connection string?

Thanks.

Alastair
alastair.cameron@blueyonder.co.uk

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2002

Added on Oct 6 2002

#odbc, #windows-and-net

2 comments

1,853 views