sas obdc drivers 发表评论(0) 编辑词条

ODBC Drivers
20071042230 张秉顺
What Is ODBC?
ODBC stands for Open Database Connectivity. ODBC is an interface standard that provides a common application programming interface (API) to access databases. Most software that runs in the Windows operating environment follows this standard for data access so that you can access data created by a variety of software applications.
ODBC functionality is provided by three main components:
the client application
the ODBC Driver Manager
the ODBC driver
Components of ODBC Functionality displays components of ODBC functionality. The ODBC Driver Manager, which was developed by Microsoft, manages the interaction between a client application and one or more ODBC drivers.
What Is the SAS ODBC Driver?
The SAS ODBC driver is an implementation of the ODBC interface standard that enables you to access, manipulate, and update SAS data sources from applications that are ODBC compliant. As Components of ODBC Functionality shows, the SAS ODBC driver uses a SAS server to access data from your SAS data sources. The SAS server can be a local and minimized SAS session or a remote SAS/SHARE server. (For more information, see SAS Servers.) If you use other ODBC drivers (such as an ODBC driver for Oracle or SQL Server) to access other data sources, those ODBC drivers might require additional software components.
什么是OBDC？
ODBC代表开放数据库连接，它是一个提供进入数据库共同申请的标准界面。许多在windows操作环境中运行的软件依据此标准可以进入其他软件建立的数据库。
ODBC主要由以下三个部分功能组成
1. 客户申请
2. ODBC驱动管理员
3. ODBC驱动
什么是ODBC驱动？
ODBC驱动是一个依据ODBC标准实施的使你能够进入、操作和更新服从OBDC标准的SAS数据源。
ODBC驱动使用一个SAS服务器连接你的SAS数据源。SAS服务器可以既是本地或者是远程的SAS/共享服务器。如果你应用其他的ODBC驱动(如ORACLE或者SQL服务器)连接数据源，那些驱动可能需要附件的软件组成。