The
Userid/Password Override option is in the
SAS/SHARE Options dialog box of the
Servers page. This option enables you to use the UID
keyword and PWD keyword in the ODBC client application so that the
SAS ODBC Driver passes the value of the UID keyword as the user ID,
and 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. Do not
enable this option if the
SAS/SHARE server is password protected (UAPW=
option in PROC SERVER). The SAS ODBC Driver cannot pass UID, PWD,
and the
SAS/SHARE server access password credentials to the
SAS/SHARE
server at the same time.
If the
SAS ODBC 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 log on, the SAS ODBC Driver
returns the credentials if the application calls the SQLDriverConnect()
method.