Hosting Test Site Domain:
Email:
ASP MS SQL 2 - DSN

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

The test requires setting up a MSSQL 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 SQL Server Web Admin tool.

You must enter the DSN name.

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

MSSQL DSN: