Documentation for Auto PSIM 1.0.1.

Previous page External database connection and setup procedure  Assigning names to table columns containing LP numbers Next page

To connect the external database, do the following:

  1. Go to the External Plates DB object settings panel.
  2. Click the Configuration button (1).

  3. In the External DB connection wizard window that opens, click the Configure… button (1). If the Auto PSIM database should be used as the external database, click Local DB (2) and go on to step 4.

    Note

    To connect to the Active tracking database, select the Local DB.

    Note

    If the external database is the Auto PSIM database then you can add the LP numbers using the Event search in the Recognizers DBs dialogue window (see Creating the Active tracking database). 

    1. As a result, the standard dialog window of database selection Data Link Properties will be displayed. Database selection process in the window Data Link Properties depends on the format of the connected database:

      • SQL Server and Access. Detailed description of database selection in the stated formats is given in the Database connection section;

        Note

        The Active tracking database is maintained in SQL Server format. When you connect to it, select the Lprex database in the Data Link Properties window.

      • FoxPro. Microsoft OLE DB for Visual FoxPro or other OLE DB provider should be used to connect to external database of the stated format;

      • Oracle. Connection to the external database of the stated format is done in the following way:

        Attention!

        To connect an Oracle database, the following conditions must be met:

        • the Oracle client is installed on the computer with the Auto PSIM Server;
        • the Oracle client is connected to the Oracle database server (the Listener component is configured).

        Note

        Detailed information about Oracle databases is given in the official reference manuals concerning this software.

    2. On the Provider tab of Data Link Properties dialog window select the Microsoft OLE DB Provider for Oracle value or Oracle Provider for OLE DB.

      • Go to the Connection tab or click the Next>> button.

      • In the Use data source name field (1), enter the server name of Oracle database to which the local client Oracle is connected.

        Note

        Oracle database name is specified upon its installation.

      • In the User name (2) and Password (3) fields, enter the user name and password to connect to the Oracle database server.

      • Set the Allow saving password checkbox (4).

        Note

        To check the connection to the Oracle database server, click the Test Connection button (5). If test connection succeeded, the message window would be displayed. To close the message window, click OK.

      • To complete the connection to external Oracle database, click OK.

  4. After the database is selected, the connection string with the selected database will be displayed in the External DB connection wizard window (1).

    Note

    The idb.exe utility is used to configure Auto PSIM databases. Its operation is described in the The idb.exe utility for converting databases, selecting database templates and making backup copies of databases section. When you switch between databases, we recommend you to refer to the Using the idb.exe utility section.

  5. The Table drop-down list (2) contains the table names in the selected database. Select the table, containing the vehicle plates from this list.

    Note

    When connecting to the Active tracking database, select the Catch_DB value.

  6. The Field drop-down list (3) contains the column names of the selected table. Select the column with vehicle plates from this list.

    Note

    When connecting to the Active tracking database, select the Plate value.

  7. Click OK (4) to save the changes and close the External DB connection wizard dialog window.

    Note.

    To quit the External DB connection wizard without saving the changes, click Cancel.

  8. As a result, the Data source connecting string, Table and Field fields (1) on the External plates DB object settings panel will be filled up.
  9. Click Apply (2).

The External Plates database connection is completed.

  • No labels