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

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version 9.2.0.8 and later
Generic Windows
***Checked for relevance on 06-Nov-2013***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms