Data Set Options for ODBC

All SAS/ACCESS data set options in this table are supported for ODBC. Default values are provided where applicable. For general information about this feature, see Data Set Options for Relational Databases.
SAS/ACCESS Data Set Options for ODBC
Option
Default Value
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting
none
LIBNAME option setting
NO
DBMS
LIBNAME option setting
none
NO
none
1024
YES
LIBNAME option setting
LIBNAME option setting
COMPAT
none
THREADED_APPS,2 or 3
1
NO
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting
SAS
a blank character
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting
none
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting
LIBNAME option setting