Teach yourself Active Web Database Programming in 21 Days
By Dina Fleet, Matt Warren, Joyce Chen, Alexander Stojanovic
B:
This book focuses on the newest Microsoft Technologies involving databases and the Internet. It covers in detail Active Database Objects, Active Data Connector, OLEDB and Active Server pages. It also covers Database Connectivity with Visual Basic. Included are chapters on ODBC and database fundamentals, Visual Basic Scripting on both the client and server side, plus a chapter on client server technology.
Active Data Object (ADO) is covered extensively by Joyce Chen, a Microsoft support representative in ODBC. There is a chapter on ADO basics, and another and Active Server pages and Record Sets. She covers Transactions, the connection object, the command object, and stored procedures. Each object of ADO is covered in detail along with the error messages and the OLEDB provider properties. Joyce also gives some of her unique insight into the pitfalls of ADO.
Matt Warren, a developer in the Active Data Connector teams delivers three intense chapters on ADC. The chapters are some of the best information written on ADC, and you can see that Matt has a strong knowledge of the information. It is presented without thrills in its entirety.
Overall this is an excellent book for getting a firm grasp on the database technology that Microsoft is developing for the Internet.
This issue of 15 Seconds contain an example of how to create an ISAPI server extension in MSVC 4.2 with ODBC 3.0 connection pooling. There is also an evaluation of ODBC 3.0, OLEDB, ADO and DAO. [Read This Article][Top]
Connection pooling might be the easiest way to speed up your dynamic web pages reading from SQL Server. Unfortunately, connection pooling within is turned off by default in Active Server pages. Probably because connection pooling is rarely understood in its entirety. This issue discusses connection pooling with ASP, ISAPI, IDC, and Visual Basic applications. Included is a discussion about ODBC 3.0 and the newest bug fix for ODBC. [Read This Article][Top]
In this article Amos El-Roy demonstrates how to create a file repository using ASP pages. A seamless approach that maximizes accessibility and lowers administrative overhead is illustrated in the article's example, which is available for download. [Read This Article][Top]
Bill Jeffries's article on Excel's Web Query tool demonstrates how to update selected spreadsheet cells instantly over an HTTP connection. [Read This Article][Top]
The help system presented in Vujosevic and Laberge's article is self contained and can be updated and altered without impacting the original Web application. Much like an online book, the help icon in the Web application dives into an application system for the help option. Each Web page has its own separate help page with a database that contains one row in a table for every calling Web page. Sample code is provided. [Read This Article][Top]
