Connect using OS Authentication (OPS$) with Oracle ODBC Driver (Doc ID 178256.1)

Goal

To demo and provide a Visual Basic script example on how to setup a connection to Oracle Database with Oracle ODBC driver using OS Authentication protocol (Operating System Authentication).

It is assumed that the customer has setup the OS Authentication process and the customer is able to connect from SQL*PLUS using OS Authentication.

You have successfully tested the connection from SQL*PLUS using one of the following:

connect / assumes that the LOCAL environment variable set to the value of the alias in the Oracle Home in the registry if connecting to a remote database.

connect /@alias

Example:


SQL> connect /@orcl
Connected.
SQL> show user
USER is "MYHOSTNAME\MYOSUSER"


You should have a successful connection from SQL*PLUS. If not, you must make sure you get a successful connection before going further ( please refer to the notes referenced at the end of this document for further help).

Solution