ADO Original Address
Http://examples.informix.com/white_papers/appeng/3rd_party/ado_iis/ado_iis_note_ibyx.html
-----------------------------------------------------------------------
Using ADO with IIS to connect to a 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 World抯 Universal Data Access strategy. ActiveX data Objects (ADO) enables users to write a application to access and manipulate Data in a database server Throug H 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 was contained in the Informix Client SDK 2.03.
Microsoft Internet Information Server
Microsoft Internet Information Server is a WEB server This 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 the Microsoft NT Server 4.0 suite.
Click here for the more information on IIS.
ActiveX Data Objects
ActiveX Data Objects (ADO) is included with Internet information Server 4.0. ADO is a 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 is 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 as file such , directories, spreadsheets, and Full-text indexes. ADO can is easily optimized for different databases. Because the ADO is used with Active Server. Pages--the dynamic content and Server-side scripting environment for Iis--developers can write conditional scripts that ex Ecute different SQL commands based upon the ODBC driver being.
Applications can is customized for different customers without has to change the code.
Click here for the more information on ADO.
2.0 Installing Informix CLI Driver
Windows NT 4.0
Informix Client SDK 2.03 needs to is 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 are needed on your system:
ODBC 3.0
NT Server 4.0
Internet Explorer 4.0 or higher
Visual Basic 5.0 or higher
All this 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 could 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
Http://www.informix.com/informix/techbriefs/cli/cli.htm for a techbrief on Informix CLI drivers.
Note This version of Informix CLI driver 2.8 only supports ODBC specifications through version 2.5.Unlike Mera NT drivers, Informix CLI drivers support BLOB/CLOB functionality.
Merant Data Direct ODBC Driver for Informix
Click here to information on Merant ODBC drivers for Informix.
5. Using Informix CLI driver with Iis/ado
Typically, when the IIS services a request for data on a Web page, many data components are involved. All processing are done on the middle tier; The end user ' s computer simply makes the request and receives the results. Processing the request for data consists of these steps:
The Active Server Pages (ASP) makes the call to the OLE-DB data provider.
The OLE-DB data provider services the request and performs query on the database; Or, in the case of the OLE-DB data provi
