VBScript needs to have the path and name of the database embedded within it.
A DSN would further contain the following details:Īs soon as you create a DSN, you can use it within an application to pull information from the resident database.ĭSNs can further be divided into two parts: To specify the type of database, you need to identify and add a Data Source Name (DSN).ĭata Source Names establish a connection to a database through an ODBC driver. This can be on an isolated machine running SQL Server or a database file on the webserver.
A data source is essentially a connection from a server or a workstation to a database.