Hosting Test Site Domain:

This is a simple test using Classic ASP to connect to a MySQL Database using a DSN.

The test requires setting up a MySQL Database via the Shared Hosting Manager.

The script checks to see if a table (my_ado) exists in the database specified, drops the table if it does, and then creates a new table (my_ado). The script then inserts 3 rows of data and writes displays the table. The script then updates this data with new dated and displays the updated table.

The test is successfuly if both the initial and updated tables are displayed. For further confirmation feel free to confirm the database actually exists with the correct data using PHPMyAdmin.

You must enter the DSN name.

This Sample Application for Classic ASP and MySQL is provided free of charge by DWAM.NT.