The SAS ODBC driver
is an implementation of the open database connectivity (ODBC) standard
that enables you to access, manipulate, and update SAS data sources.
These data sources can include SAS data sets, flat files, VSAM files,
as well as data from any database management system (DBMS) for which
you have licensed
SAS/ACCESS software. For information about how to
access data from other Windows applications that comply with the ODBC
standard, see the SAS Help and Documentation.
The SAS ODBC Driver
accesses data by communicating with either a local or remote (
SAS/SHARE)
SAS server session using the TCP/IP protocol. The TCP/IP protocol
enables users to access remote SAS servers on a variety of host platforms.
A SAS server is a SAS procedure (either PROC SERVER or PROC ODBCSERV)
that runs in its own SAS session; it accepts input and output requests
from other SAS sessions and from the SAS ODBC driver on behalf of
the ODBC-compliant application. For remote access to SAS data, a SAS
server must be installed on the server machine, but not on the client
machine.
The SAS ODBC Driver
is included with Base SAS. Remote server configurations that use
the SAS ODBC driver require that these SAS products be installed:
For details about installing
and configuring the SAS ODBC Driver, see the installation documentation
for SAS under Windows. For more information about configuring and
using the SAS ODBC Driver, see
SAS Drivers for ODBC: User's Guide.