Set up odbc connection for access on mac

broken image

VBScript needs to have the path and name of the database embedded within it.

broken image

broken image

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.

broken image

A data source is essentially a connection from a server or a workstation to a database.