用ado串連Informix的資料

來源:互聯網
上載者:User
ado 原文地址
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 Merant drivers, Informix CLI drivers support BLOB/CLOB functionality.

Merant Data Direct ODBC Driver for Informix
Click here for 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 is 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 the query on the database; or, in the case of the OLE-DB data provi



相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。