Hosting Test Site Domain:

This is a simple test using Classic ASP to connect to a MySQL Database (without 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 server name, database name(username), and database password.

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

MySQL Server:  
MySQL DB Name (username):  
MySQL Password: