Using SQL and ADO to provide data for your Web application can seem daunting, but these ten tips can noticeably improve your results.
Retrieving data from a SQL Server™ database using ActiveX® Data Objects (ADO) and Active Server Pages (ASP) challenges many Web developers. It can be hard to maximize performance, scalability, and robustness in a specific installation. This article offers specific recommendations to help improve your data access. While much of this information can apply to other databases, I'll focus on SQL Server and use the familiar Pubs sample database for illustration purposes.
|
