Skip to main content

What kinds of Authentication are available for the ODBC Oracle Wire Protocol Driver?


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:

(0 users)Average rating

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.

Rate this page:


(0 users)Average rating

Add comments

Document information

SPSS Modeler

Modeler


Software version:
14.2


Operating system(s):
Windows


Reference #:
1597978


Modified date:
2013-01-22

Translate my page

Content navigation