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 184.108.40.206 and later
***Checked for relevance on 06-Nov-2013***
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.
SQL> connect /@orcl
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).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!