My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle ODBC Driver - Version and later
Generic Windows


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


SQL> connect /@orcl
SQL> show user

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).


To view full details, 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 a vibrant support community of peers and Oracle experts.