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

Document information


More support for:

SPSS Modeler
Modeler

Software version:

14.2

Operating system(s):

Windows

Reference #:

1597978

Modified date:

2013-01-22

Translate my page

Machine Translation

Content navigation