ODBC Drivers

The Microsoft® ODBC Driver for DB2 enables users to access IBM Data Base 2 (DB2) from within an ODBC-aware application. ODBC defines a standard set of interfaces that provide access to disparate databases. The ODBC Driver for DB2 combines the data access of ODBC with the underlying Microsoft Distributed Relational Database Architecture (DRDA) Application Requester also used by the Microsoft OLE DB Provider for DB2. Using this combination of technologies, the ODBC Driver for DB2 can provide database access to IBM's Distributed Relational Database Architecture and IBM DB2.

Organizations have invested in secure, robust, enterprise-wide data storage and management systems. DRDA is a set of rules for distributing or extending relational data from one computer to another, such as a server computer to an IBM DB2 database server running on a mainframe or an AS/400 computer. By combining the ODBC and DRDA architectures, Microsoft allows organizations to preserve their investments in an existing data management infrastructure, while extending data access to all enterprise-wide DB2 data sources.

The ODBC Driver for DB2 can be used interactively or from an application program to issue SQL statements and execute DB2 stored procedures. From Microsoft Excel, users can import DB2 tables into worksheets and use Excel graphing tools to analyze the data. From Microsoft Access, users can import from and export to DB2. With Microsoft Internet Information Server (IIS), developers can publish DB2-stored information to users through a Web browser.

This section contains: