This is a simple test using Classic ASP to connect to a MSSQL Database (without a DSN).
The test requires setting up a MSSQL Database via the Shared Hosting Manager.
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.
You must enter the server name, database name(username),
and database password.
This Sample Application for Classic ASP and MSSQL is provided free of charge by DWAM.NT