This script demonstrates connecting to a MSSQL database in ASP without a DSN. The script will make the connection and then output all the rows of a specified table.
Dim objConn, rsRecord, strSQL, tableName, address, username, password, database
Define the variables we will use in this script.
Set objConn = Server.CreateObject("ADODB.Connection")
Create the connection object. We will use ADO for the connection.
address...
Read more...