The
Userid/Password Override option is in the
SAS/SHARE Options dialog
box on the
Servers page. This option enables
you to use the UID keyword and PWD keyword in the ODBC client application.
The driver passes the value of the UID keyword as the user ID, and
passes the value of the PWD keyword as the user login password to
the
SAS/SHARE server or SPD Server. The values for UID and PWD in
the ODBC client application override the values that are stored in
the DSN definition.
If the driver fails
to authenticate with the
SAS/SHARE server or the SPD Server, the driver provides a prompt for the
user ID and password credentials (up to three times). If the user
ID and password credentials are successfully authenticated, then the
Userid/Password Override check box is selected. After
a successful login, the driver returns the credentials if the application
calls the SQLDriverConnect() method.
Note: For sites that use a
SAS/SHARE
server with a user password (the UAPW= option), the password must
be stored in the DSN definition. The
SAS/SHARE server password has
no interaction with the
Userid/Password Override setting, and the driver does not prompt for the credentials if authentication
fails.