Technote (troubleshooting)
Problem(Abstract)
Attempting to connect using a proxy user, getting invalid user/password error message.
Symptom
Attempting to connect using a proxy user, getting invalid user/password error message.
Cause
Attempting to connect using a proxy user, getting invalid user/password error message.
Environment
Windows, Modeler 14.2
Diagnosing the problem
According to the article "What kinds of Authentication are available for the ODBC Oracle Wire Protocol Driver?" from DataDirect's knowledge base, connection using proxy user is not supported for Oracle ODBC driver.
Resolving the problem
According to the article "What kinds of Authentication are available for the ODBC Oracle Wire Protocol Driver?" from DataDirect's knowledge base, connection using proxy user is not supported for Oracle ODBC driver, which supports only the following 4 types of authentication for the moment:
AuthenticationMethod (AM) AuthenticationMethod={1 | 3 | 4 | 5}
Determines the security method the driver uses to authenticate the user to the server when a connection is established.
When set to 1, the driver sends the user ID in clear text and an encrypted password to the server for authentication.
When set to 3, the driver uses client authentication when establishing a connection. The database server relies on the client to authenticate the user and does not provide additional authentication.
When set to 4, the driver uses Kerberos authentication. This method supports both Windows Active Directory Kerberos and MIT Kerberos environments.
When set to 5, the driver uses both Kerberos authentication and user ID and password authentication. The driver first authenticates the user using Kerberos. If a user ID and password are specified, the driver reauthenticates using the user name and password supplied. An error is generated if a user ID and password are not specified. If the specified authentication method is not supported by the database server, the connection fails and the driver generates an error.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.