日期:2009-04-07  浏览次数:20903 次

原文地址
http://examples.informix.com/white_papers/appeng/3rd_party/ado_iis/ado_iis_note_ibyx.html

-----------------------------------------------------------------------
Using ADO with IIS to connect to an Informix Database
Introduction
Informix CLI Driver
Microsoft Internet Information Server
ActiveX Data Objects
Installing Informix CLI Driver
Windows NT 4.0
Installing IIS / ADO
Windows NT 4.0
Specifications for Informix ODBC Drivers

Using Informix CLI driver with IIS/ADO

Configuration

Examples
Detailed Steps for Windows NT Samples

Conclusion
Useful Links
History
1. Introduction
IIS and ADO are part of Microsoft抯 Universal Data Access strategy. ActiveX Data Objects (ADO) enables users to write an application to access and manipulate data in a database server through an OLE DB provider. ADO's primary benefits are ease of use, high speed, low memory overhead, and compactness. ADO supports key features for building client/server and web-based applications.

Goals for this integration note were:

To understand the working of ADO and IIS.
To investigate the working Informix CLI driver with ADO with IIS.
To investigate the working Informix CLI driver with ADO with Visual Basic.
Informix CLI Driver
We used Informix CLI Driver 2.8. This driver is contained in the Informix Client SDK 2.03.

Microsoft Internet Information Server
Microsoft Internet Information Server is a Web server that enables users to publish information on a corporate intranet or on the Internet. The IIS supports HTTP, FTP and gopher services. IIS 4.0 is included in Microsoft NT Server 4.0 suite.

Click here for more information on IIS.

ActiveX Data Objects
ActiveX Data Objects (ADO) is included with Internet Information Server 4.0. ADO is an ODBC standard-compliant set of interfaces that expose the database functionality in databases through accessible objects. Many shortcuts speed up common scripting operations. ADO can be used with any language, such as JavaScript, VB Script, and Perl.

Because ADO works with OLE-DB providers, it can access a variety of data sources. Data sources include both traditional relational database management systems and non-database sources such as file systems, directories, spreadsheets, and full-text indexes. ADO can be easily optimized for different databases. Because ADO is used with Active Server. Pages--the dynamic content and server-side scripting environment for IIS--developers can write conditional scripts that execute different SQL commands based upon the ODBC driver being used.

Applications can be customized for different customers without having to change the code.

Click here for more information on ADO.


2.0 Installing Informix CLI Driver
Windows NT 4.0
Informix Client SDK 2.03 needs to be installed to use ADO with IIS to access Informix data. The Informix CLI Driver 2.8 comes with the Development Kit. Download Informix Client SDK 2.03.

3.0 Installing IIS/ADO
In order to install IIS/ADO, the following software is needed on your system:

ODBC 3.0
NT Server 4.0
Internet Explorer 4.0 or higher
Visual Basic 5.0 or higher
All these products can be obtained from Microsoft Corp. For details refer to the Microsoft site.

ActiveX Data Objects (ADO) is included with Internet Information Server 4.0. You may need to install ADO 2.0.

The IIS site provides additional information on administration and maintenance of IIS and its components.


4. Specifications for Informix ODBC Drivers
Informix CLI Driver
See http://www.informix.com/informix/techbriefs/cli/cli.htm for a techbrief on Informix CLI drivers.

Note that the current version of Informix CLI driver 2.8 only supports ODBC specifications through version 2.5.Unlike