ASP 2 - database use
Webdevonline Extra
Site Index

What are they used for?

These are comonly encountered where dynamic input is required of the user - selecting from a menu or inputting user details. The pages are basically processing pages.

They send and retrieve information to be stored or retrieved serverside. They process all sorts of material

  • databases
  • URL variables
  • server variables
  • form variables
  • stored procedures
  • other sources of dynamic content.

The ASP or JSP are processing pages. They are usually linked to a normal HTML page. The HTML page passes the processing info to ASP which processes it and presents the results

What are the requirements for ASP JSP?

You need to have your hosting package supporting ASP or JSP pages

What do I need to connect to databases using ASP?

You need to have support for the database you want to use from your hosting company. Their server will need to be running on a Windows platform if you want to use MS Access

See ASP2 for more details on making databases using ASP


An example of ASP pages in action

Plymouthoncourse Learning site

The main index page is an asp page. When the user enters a search criteria another asp page contacts the database, and extracts the information. The results are presented on a normal HTML page

Examples of some ways in which ASP/JSP pages can be used

All the applications are designed for serverside processing tasks. Processing takes place in the background and on the spot. Most common uses are to process user input to search an organisation's database, user input when accessing a membership site (eg banking site). Look at some examples of free applications below. Read the licence for each carefully.

Free ASP Tools
ASP Guestbook ASPGuest by CJWSoft www.CJWSoft.com

This is a guestbook application written in ASP that uses an Access database.

Mailing List PacMail is an easy to use mailing list administrator

These applications are free, but must be downloaded personally

Site Search - This application uses ASP and must be run through a web sever supporting ASP.

ASP Counter - The hit counter uses ASP and must be run through a web sever supporting ASP.

Web Wiz Forums - . This free bulletin board system comes ready to run, easy to customise and has many advanced features


Sample Access Database from Webdevonline.co.uk

Honest Dave's Car Database - this is an Access database connected viaADODB and displayed using an ASP processing page.This database is hosted by a host supporting ASP processing and is hosted on Windows servers.

Look at detailed example code for an ASP connection as used in the database

Web Wiz Guestbook Example

Easy to install and customise with many advanced features, including email notification, Anti-spam, emoticons, password protected admin area, and more. Access and SQL server versions.

 

ASP Graphical Hit Counter

Search for ASP Applications

Search this site or the web powered by FreeFind

Site search Web search
     Webdevonline Extra