Using the CONNECT TO statement with the SQL procedure in SAS/ACCESS Interface to ODBC generates the following error:

NOTE:  Credential obtained from SAS metadata server.
ERROR: Provided buffer is not large enough.

This error occurs when the password defined for the authentication domain in the metadata contains more than 90 characters.

Workaround

To circumvent this issue, use a LIBNAME statement instead of the CONNECT TO statement.