In SAS/ACCESS^® Interface to Aster nCluster, the following error occurs when you use the COMPLETE=, the NOPROMPT=, or the REQUIRED= connection options in a LIBNAME statement:

ERROR: CLI error trying to establish connection: [Microsoft]
[ODBC Driver Manager] Data source name not found and no default driver specified
ERROR: Error in the LIBNAME statement.

An error message is received if there is a blank space within the quotation marks in the connection option. For example, the following LIBNAME statement connects successfully to the database:

However, in the following LIBNAME statement, the database connection fails because a blank space appears before the SERVER= parameter:

This problem occurs because the ODBC driver and driver manager do not permit blank spaces within the quotation marks of the NOPROMPT="CLI-connection-string", REQUIRED="CLI-connection-string", and COMPLETE="CLI-connection-string" connection options. To avoid the problem, make sure that all blank spaces within the quotation marks are removed.

Operating System and Release Information