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...

This script demonstrates connecting to a MySQL database in ASP with a DSN. The script will make the connection and then output all the rows of a specified table. Dim objConn, rsRecord, strSQL, tableName, dsnName, dsnUser, dsnPass, 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. dsnName...

This script demonstrates connecting to a MySQL 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...

This script demonstrates connecting to a MS Access database in ASP with a DSN. The script will make the connection and then output all the rows of a specified table.

Dim objConn, rsRecord, strSQL, tableName, dsnName, dsnUser, dsnPass
Define the variables we will use in this script....

This script demonstrates connecting to a MS Access database in ASP without a DSN. The script will make the connection and then output all the rows of a specified table. Dim objConn, dbPath, rsRecord, strSQL, tableName 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. dbPath = "/db/test.mdb"     'The...