Establishing a System Data Source Name (DSN)

After you have created your database, you must associate it with your system by establishing a Data Source Name (DSN). A DSN is a data structure that contains the information about a database that an Open Database Connectivity (ODBC) driver needs to connect to it, such as the name, directory, and driver of the database, and the ID and password of the user.

To use a DSN-less connection with ODBC authentication, refer to Using a DSN-Less Connection with ODBC Authentication.

To establish a system DSN

1. In Windows, click Control Panel, Administrative Tools > Data Sources (ODBC). The ODBC Data Source Administrator appears.
   
   

2. Click the System DSN tab.
   
   

3. Click Add. The Create New Data Source dialog box appears.
   
   

4. Click the appropriate driver on the list. For example, to use a Microsoft Access database, click Driver do Microsoft Access (*.mdb).

5. Click Finish. The ODBC Microsoft Access Setup dialog box appears.
   
   

6. Type the Data Source Name and Description. The default DSN is GSFTP Server.

7. In the Database area, click Select to specify the database file to use, then click OK.

8. Click OK to close the ODBC Microsoft Access Setup dialog box and save the changes.