DBMS Access Using the LIBNAME Statement (2)

Accessing Other Vendors' DBMS Data

DBMS Access Using the LIBNAME Statement

Engine Connection Options

SAS/ACCESS engine connection options are options that you specify to connect to a particular database. These options are passed to the database management system, so their content and format vary according to the system. Typical SAS/ACCESS engine connection options include a

user name
password
database name.

On some DBMSs, if you specify the appropriate system options or environment variables for your database, you can often omit the connection options. See your DBMS-specific documentation for details.

Examples

In this example, the libref Mydblib connects to an ORACLE database. The SAS/ACCESS engine connection options are USER=, PASSWORD=, and PATH=, where PATH= specifies an alias for the database specification.

     libname mydblib oracle user=testuser   
             password=testpass path=myorapath;

In this example, the libref Myodbc uses the ODBC engine to connect to a Microsoft SQL Server database. The SAS/ACCESS engine connection options are UID=, PWD=, and DSN=.

     libname myodbc odbc uid=testuser pwd=testpass 
             dsn=sqlservr;

If connection options include characters that are not allowed in SAS names, enclose the values of the options in quotation marks.