Page History

To connect the external database, do the following:

1. Open the Hardware tab in the System Settings window (1).
2. Select the External Plates Database object in the object tree (2)Go to the External Plates DB object settings panel.
   
3. Click the Configuration button to open the Configuration window.(1).

4. In the External DB connection wizard window that opens, click Click the Configure… button in the appeared window (1).
   Image Removed

   Info

   title	Note.

    If the Auto-Intellect

   PC database shold be

    database should be used as the external database, click Local DB (2) and go on to step

   6.

   4.

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

   Image Added

   Info
   title Note.
   If the external database is the Auto-Intellect PC database  database then you can add numbers with the help of Vehicle Plate Search program the LP numbers using the Event search in the Recognizers DBs dialogue window (see Creating the Active tracking database section in the reference manual Auto Intellect software package: Operator's guide).

   The

   1. As a result, the standard dialog window of database selection Data

   link properties

   1. Link Properties will be displayed

   in result

   1. . Database selection process in the window Data

   link properties

   1. Link Properties depends on the format of the connected database:

   5.1

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

   of the Intellect Software Package: Administrator's Guide document.
   5.2

   1. • .

        Info
        title 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.

   5.3

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

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

        
        

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

   5.3.1

   1. • 
        

   2. On the Provider tab of Data

   link properties dialog

   1. Link Properties dialog window select the Microsoft OLE DB Provider for Oracle value or Oracle Provider for OLE DB.
      Image Modified

   5.3.2

   1. • Go to the Connection tab

   and

   1. • or click

   Next.
   5.3.3 Enter

   1. • the Next>> button.

      • In the Use data source name field (1), enter the server name

   and

   1. • of Oracle database to which the local client Oracle is connected

   in the Use data source name field (1)

   1. • .

        Info
        title Note.
        Oracle database name is

   entered

   1. • specified upon its installation.

        Image Modified

   5.3.4

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

   5.3.5

   1. • Set the Allow saving password checkbox (4).

        Info
        title 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

   it is necessary to

   1. • , click OK.

   Image Removed

   1. • Image Added

   5.3.6

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

5. After selecting the database (see step 5) the database is selected, the connection string with the selected database will be displayed in the External DB connection wizard window there will be displayed connection string with the selected database (1).
   
6. In the

   The Table drop-down list (2) contains the table names

   of tables

   in the selected database

   are displayed

   . Select the table, containing the vehicle plates from

   the

   this list.

   Info
   title Note
   When connectting to the Active tracking database, select the Catch_DB value.

   
   

7. The Field drop-down

   In the Field

   list (3) contains the column names of

   columns on

   the selected table

   are displayed

   . Select

   from this list

   the column with vehicle plates from this list.

   Info
   title Note
   When connectting to the Active tracking database, select the Plate value.

   
   

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

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

   
   

9. Click OK (46) to save , change or the changes and close the External DB connection wizard dialog window.

   Info
   title Note.
   To quit the external External DB connection wizard without saving the changes, click Cancel.

   
   

10. The Connecting As a result, the Data source connecting string, Table and Field fields (1) on the External plates databaseDB object settings panel will be filled in result of performing the operation (1) up.
    
11. Click Apply (2).

The External Plates database connection is completed.