Page History

To connect the external database, do the following:

1. Open the Hardware tab in the System Settings window (see Fig. 7.6—1, 1).
2. Select the External Plates Database object in the object tree (see Fig. 7.6—1, 2).
   Image Added
3. Click the Configuration button to open the Configuration window (see Fig. 7.6—1).

...

1. .

...

2. Click the

   «Configure…»

   Configure… button in the appeared window (

   Fig. 7.6—2,

   1).
   

...

1. Image Added

...

1. Info

...

1. title

...

1. Note.

1. If the Auto-Intellect PC database shold be used as the external database click Local

...

1. DB (2) and go on to step 6.

   Info

...

1. title Note.

   If the external database is the Auto-Intellect PC database then you can add numbers with the help of

...

1. Vehicle Plate Search program (see

...

1. Forming the Active tracking

...

1. database section in the reference manual

...

1. Auto Intellect software package: Operator's

...

1. guide).

2. The standard dialog window of database selection

   «Data

   Data link properties

   »will

   will be displayed in result. Database selection process in the window

   «Data

   Data link

   properties»

   properties depends on the format of the connected database:
   5.1 SQL Server and Access. Detailed description of database selection in the stated formats is given in the Database connection section

   «Database connection»

   of the

   «Intellect PC

   Intellect Software Package: Administrator

   guide»

   's Guide document.
   5.2 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 Oracle. Connection to the external database of the stated format is done in the following way:

   Note
   title

...

1. 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 On the

   «Provider»

   Provider tab of

   «Data

   Data link

   properties»

   properties dialog window select the

   «Microsoft

   Microsoft OLE DB Provider for

   Oracle»

   Oracle value or

   «Oracle

   Oracle Provider for OLE

   DB» (Fig. 7.6—3).

...

2. Go to the «Connection» tab and click «Next» (Fig. 7.6—4).

DB.
Image Added5.3.2 Go to the Connection tab and click Next.
5.3.3 Enter the server name and of Oracle database to which the local client Oracle is connected in the

«Use

Use data source

name»

name field (

Fig. 7.6—4,

1).

Info
title Note.
Oracle database name is entered upon its installation.

...

1. In the «User name» (Fig. 7.6—4, 2) and «Password» (Fig. 7.6—4,

   Image Added
   5.3.4 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 Set the

   «Allow

   Allow saving

   password»

   password checkbox (

   Fig. 7.6—4,

   4).

   Info
   title Note.
   To check the connection to the Oracle database server click the

...

1. Test Connection button (

...

1. 5). If test connection succeeded the message window would be displayed. To close the message window it is necessary to click

...

1. OK.

...

1. Image Added

   
   5.3.6 To complete the connection to external Oracle database click

   «OK»

   OK.

2. After selecting the database (see step 5) in the «External External DB connection wizard» wizard window there will be displayed connection string with the selected database (Fig. 7.6—6, 1).
   

...

1. Image Added
2. In the Table list (

...

1. In the «Table» list (Fig. 7.6—6, 2) the names of tables in the selected database are displayed. Select the table, containing vehicle plates from the list.
2. In the «Field» Field list (Fig. 7.6—6, 3) the names of columns on the selected table are displayed. Select from this list the column with vehicle plates.

3. Click

   «OK» (Fig. 7.6—6,

   OK (4) to save, change or close the External DB connection wizard dialog window.

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

...

1. Cancel.

2. The «Connecting string» Connecting string, «Table» Table and «Field» Field fields on the «External External plates database» database settings panel will be filled in result of performing the operation (Fig. 7.6—7, 1) .
   

...

1. Image Added
2. Click Apply (

...

1. Click«Apply» (Fig. 7.6—7, 2).

External Plates database connection is completed.