Connect using OS Authentication (OPS$) with Oracle ODBC Driver
Last updated on JULY 05, 2017
Applies to:Oracle ODBC Driver - Version 18.104.22.168 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).
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