A DBMS password that has been encoded with the PWENCODE procedure cannot be specified in a SAS/ACCESS^® Interface to ODBC connection that uses COMPLETE=, PROMPT=, REQUIRED=, or NOPROMPT= connection options.

The connection strings that are specified by the DSN=, USER=, and PWD= options in the LIBNAME statement are passed 'as is' to the database.

In the following example, the DBMS password is encoded with PROC PWENCODE and the encoded value is used in the statement:

When you submit this code, the following errors are returned:

To circumvent this problem, you must use an unencoded password when you specify the COMPLETE=, PROMPT=, REQUIRED=, and NOPROMPT= options.

Operating System and Release Information