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.