Learn how to create an ASP script in VBScript to connect to the MSSQL database.
In this example we will show you how to connect to the MSSQL database and print sale details stored in the database. To clearly illustrate the procedure, we are using a MSSQL database named db123456789. Within this Access database, there is one table named tbl_Sales.
You can create the following script to query the database, but keep in mind to close the connection once you are done. This will ensure that the memory resources will be released. As best practice, only a minimum connections should be open.