SAS ODBC Driver
(Release 9.1 - APR 2004)
The Release 9.1 SAS ODBC Driver enables you to access, update, and manipulate SAS data from ODBC-enabled applications, such as Microsoft Access, Microsoft Excel, Visual Basic, and PowerBuilder. The SAS ODBC Driver provides read and write access to databases such as IBM DB2 and ORACLE via SAS/ACCESS software running on remote SAS servers. Furthermore, SAS views can be defined to join database tables from different vendors, creating a virtual data warehouse for your ODBC-enabled applications.
The SAS ODBC Driver uses the TCP/IP protocol to access your data on a local or remote data server on a variety of host platforms. It is not required that the SAS System be installed on the client machine to access remote SAS data (SAS/SHARE server) via the SAS ODBC Driver. Accessing local SAS data requires Base SAS software to be installed on the client machines. A remote server requires that Base SAS software, SAS/SHARE software, and SAS/SHARE*NET software is installed.
The SAS ODBC Driver also enables access to Scalable Performance Data Server. SAS data sets and SPDS data sets are interchangeable via use of the LIBNAME statement engine option in either SAS or SPDS. The SAS SPD Server product is multithreaded server software which takes advantage of Symmetric Multiprocessor hardware to speed up access to SAS data. Contact your SAS representative or see the SAS website at www.sas.com for more information about the SAS SPD Server product.
Microsoft Data Access Components (MDAC) Version 2.7 or higher are required by the SAS ODBC Driver. Note: An earlier version of the MDAC might work but is not supported by SAS. MDAC is available from the Microsoft web site.
- The SAS ODBC Driver will work with Versions 7, 8, and 9 of the SAS System.
- You can install the SAS ODBC Driver on Windows NT(r), Windows(r) 2000, or Windows(r) XP. Other Versions of Windows(r) have not been tested for use with the SAS ODBC Driver and are considered experimental, and may cause undetected errors.
SAS ODBC Driver Download Packages
SAS ODBC Driver download package is listed by platform in the
table below. Selecting the Request Download button will allow you to
see the license terms and download SAS ODBC Driver.
SAS ODBC Driver
For questions you may have about this product, please
contact our Product Support Group