Creating an ODBC Connection

These instructions assume that you have Open Database Connectivity (ODBC) set up beforehand. You can create new ODBC connections by following these instructions if you know the database name to connect to and the user ID to access the database with.

To connect to a database using ODBC:
  1. From the Database Connection list, select New Connection and then click the Manage Connection List and Choose Connection button.
  2. In the Database Connection dialog, select the ODBC radial button and then click the button beside it.
  3. In the Select Data Source dialog, select an existing ODBC connection by doing one of the following:
    • On the File Data Source tab, use the Look in drop-down list or the Up button to locate the database you want to upload to and select it.
    • On the Machine Data Source tab, double-click the data source driver you want to connect to and navigate to the database you want to upload to and select it.

    If you do not have an existing ODBC connection, click New to open the Create New Data Source wizard and create one. Select the connection after creating it.

  4. Click OK to use your selection.

    The Database Connection dialog populates with the ODBC connection information. Click OK to save your selection.