This script demonstrates connecting to a MSSQL database in ASP.NET with a DSN. The script will make the connection and then output all the rows of a specified table.
// Set your connection string.
// Replace id, pwd, database_name and mssqlX.easycgi.com with appropriate values
Dim connString as string = "user id=id; password=pwd; initial catalog=database_name; data source=mssqlX.easycgi.com"
Dim myConnection as New SqlConnection(connString)...
Read more...