ODBC Connect Using TAF Preconnect Method Returns ORA-01017

(Doc ID 275585.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Oracle ODBC Driver - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.


Trying to use the Oracle ODBC driver and TAF PRECONNECT method results in 

ORA-1017 invalid username/password; logon denied.

The behavior can be reproduced with the a simple ODBC connection (the "Test Connection" button, for example) and the following TNSNames.ora entry.:

1. Edit tnsnames.ora and add the following connect string.


2. Create a new Oracle ODBC DSN and refer to the "taf_test" alias

3. Perform a test connection from the ODBC Administrator->Oracle dsn->configure



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