DSN Setup - CAESAR II - Help

CAESAR II Users Guide

Language
Русский
Product
CAESAR II
Search by Category
Help
CAESAR II Version
12

To use the CAESAR II data export facility, you need to set up a Data Source Name (DSN) on the system. DSNs contain information regarding where the database resides on the computer and how to communicate with it (for example, what driver to use). CAESAR II has capabilities to export data to either an Access database or an Excel spreadsheet, though you only need to set up a DSN for an Access database to allow use of this feature. The name of a DSN is fixed (read-only) by ICAS.

The CAESAR II installation program is designed to set up DSNs automatically. However, in the event that the DSNs are not set up, follow the procedure below.

Setting Up the Data Source Name:

  1. From the Start menu, select Settings > Control Panel.

  2. Double-click ODBC Data Sources, and click User DSN.

  3. Click Add.

    The system displays a dialog box similar to the figure below.

    Follow steps 4 through 7 for Microsoft Access DSN Setup ONLY.

  4. Select the Microsoft Access Driver (*.mdb, *.accdb), and click Finish.

    The system displays a dialog box similar to the one below. You are prompted to select your database.

    The data source name must be the C2_OUT_ACCESS. The description is an optional field, and can hold any description information.

  5. Enter the Data Source Name and the Description. Click Select to select the CAESAR II template database.

    CAESAR II is supplied with a template database that contains the structure to hold data exported from the software. This file is named caesarII.mdb and is present in the system directory of your CAESAR II installation directory.

  6. Select the file, and click OK.

    The system returns you to the ODBC Microsoft Access Setup dialog box.

  7. Click OK.

    The C2_OUT_ACCESS has been added to list of available user DSNs.

You have now successfully completed the Access DSN setup.

This above process needs to be performed only once per computer.