Using SQL-DMO To Backup and Verify a Database ASP / Database Integration
This article "Using the SQL Distributed Management Objects", provided an overview of SQL-DMO. This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.
ASP Data Access for Beginners ASP / Database Integration
The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).
Upload - to database, or not to database? ASP / Database Integration
To database or not to database? What to do with uploaded files on server-side? This article contains performance tests of several store-file methods in server-side ASP.We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command.
Fun With Stored Procedures ASP / Database Integration
A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others ... A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it.
Custom Paging in ASP - Fast And Easy ASP / Scripts
This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.
Display an Excel DB ASP / Excel and ASP
Excel can act as a database. It's not the fastest or the best. However, for small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale.
Connecting To A Database and Retrieving Results in 9 Easy Steps ASP / Database Integration
Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it's hard to separate the database stuff from the rest of the code so I made this example.
Creating a Category Site with ASP ASP / Scripts
In this article we will implement a catalog site that is build with Active Server pages and SQL Server. Along with the implementation there is source code and a discussion of the advantages and disadvantages of creating a catalog site that gets it's content from a database. Included are pages for displaying products, creating a menu page, category page, and running a search across a database.
How to connect to an Access database with a DSN ASP / Database Integration
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. In this tutorial we will show you how to connect with a DSN to an Access database called 'examples.mdb' and retrieve all the records from the table 'cars'. Everything is commented so you won't have trouble.
Hit counter Using Stored Procedure ASP / Counters
This simple counter uses only one stored procedure to update and display hits. So it uses less server memory. The database back-end is SQL Server. But you may easily modify procedure to use with MS Access