PROC DS2 generates an error when you attempt to read an unsupported database


Errors like the following are written to the SAS log when you attempt to read an unsupported database using the DS2 procedure:

ERROR: BASE driver, schema name DB1 was not found for this connection
ERROR: Table "DB1.ANTIBIOTIC" does not exist or cannot be accessed

For a list of the databases that are supported with DS2, please see DS2 Supported Data Sources.

The LIBNAME statements for the following SAS/ACCESS® engines are not supported with PROC DS2:

OLEDB
Sybase
Vertica
Impala
Informix
SQL Server

You can use the ODBC LIBNAME engine with PROC DS2 if your data source is ODBC compliant.