Documentation for Auto Intellect 5.5. Documentation for other versions of Intellect is available too.

Previous page External database connection and setup procedure  Assigning names to table's columns containing vehicle plates 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-Intellect 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-Intellect 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:

        Attnetion!

        To connect the Oracle database meet the following conditions:

        • On the PC with the Auto-Intellect server there installed the Oracle client.
        • Oracle client is connected to Oracle database (Listener component is set up).

        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).

  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 connectting 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 connectting to the Active tracking database, select the Plate value.

  7. To add a new table to the selected database, enter the table name in the New Table field (4) and click the Add button (5).

    Note

    • The name of the new table should not contain numbers and be a reserved keyword of Microsoft SQL Server (for details, see Reserved Keywords (Transact-SQL)).
    • The new table will have a structure similar to the one indicated in the Table drop-down list (2).

  8. Click OK (6) 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.

  9. 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.
  10. Click Apply (2).

The External Plates database connection is completed.

  • No labels