This article discusses the use of ASP and ADO to create a web-based form that interfaces with a database, allowing you to run queries to view or modify your data over the web. This article discusses the use of ASP and ADO to create a web-based form that interfaces with a database, allowing you to run queries to view or modify your data over the web. Begins with a general discussion of what pooling is and the benefits it provides. This article teaches the very basics of using Visual Basic and ADO to connect to a Microsoft Access database. Pooling is verified using SQL Profiler and Performance Monitor.
Source code is included.
This excellent tutorial introduces ADO and explains how to use it to connect to databases from web sites. Element K Asli Bilgin explains how datashaping allows you to create recordsets within recordsets, all with a single ADO object. Readers are provided with a practical example of filling a treeview control using the ADO hierarchical data engine. This write-up shows you how to implement connection pooling with sample code and sample tests. But according to this LockwoodTech article, if you are using ASP destroy your connections explicitly this will have no affect on pooling.