Problem Note 69539: ODBC CASLIB fails to connect and receives the error: "ERROR: ERROR: LDAP authentication failed for user 'user ID'"
 |  |  |  |
In SAS/ACCESS® Interface to ODBC, if you try to connect to a database using a password that contains a special character, the connection might fail. As a result, an error similar to the following occurs:
ERROR: The connection to the data source driver failed.
ERROR: ERROR: LDAP authentication failed for user 'user ID'
ERROR: Function failed.
ERROR: ERROR: LDAP authentication failed for user 'user ID'
ERROR: Function failed.
To circumvent this issue, change your password. Do not include special characters such as the following in your password: @. &, ^
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for x64 | Viya | |
| Linux for x64 | Viya | |||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-10-31 11:25:58 |
| Date Created: | 2022-09-09 16:08:04 |