Connecting the external database

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).
3. Click the Configuration button to open the Configuration window (see Fig. 7.6—1).

Fig. 7.6—1 External Plates Database connection. Connection setup window

1. Click the «Configure…» button in the appeared window (Fig. 7.6—2, 1).

Fig. 7.6—2 External DB connection wizard
Note1. If the Auto-Intellect PC database shold be used as the external database click Local database (see. Fig. 7.6—2, 2) and go on to step 6.
Note2. If the external database is the Auto-Intellect PC database then you can add numbers with the help of «VehiclePlateSearch» program (see «Forming the Active tracking database» in the reference manual «Auto Intellect software package: Operator's guide» ).

1. The standard dialog window of database selection «Data link properties »will be displayed in result. Database selection process in the window «Data link properties» depends on the format of the connected database:
   1. SQL Server and Access. Detailed description of database selection in the stated formats is given in the section «Database connection» of the «Intellect PC: Administrator guide» document.
   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.
   3. Oracle. Connection to the external database of the stated format is done in the following way:

Note! To connect the Oracle database meet the following conditions:

1. On the PC with the Auto-Intellect server there installed the Oracle client.
2. 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.

1. 1. 1. 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» (Fig. 7.6—3).

Fig. 7.6—3 Selecting the provider for Oracle database

1. 1. 1. Go to the «Connection» tab and click «Next» (Fig. 7.6—4).
      2. Enter the server name and of Oracle database to which the local client Oracle is connected in the «Use data source name» field (Fig. 7.6—4, 1)

Note. Oracle database name is entered upon its installation.
Fig. 7.6—4 Oracle database connection

1. 1. 1. In the «User name» (Fig. 7.6—4, 2) and «Password» (Fig. 7.6—4, 3) fields enter the user name and password to connect to the Oracle database server.
      2. Set the «Allow saving password» checkbox (Fig. 7.6—4, 4).

Note. To check the connection to the Oracle database server click the «Test Connection» button (Fig. 7.6—5, 5). If test connection succeeded the message window would be displayed. To close the message window it is necessary to click «OK» (Fig. 7.6—5).
Fig. 7.6—5 Test connection succeeded.

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

Fig. 7.6—6 Column selection with vehicle plates

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» 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, 4) to save, change or close the External DB connection wizard dialog window.

Note. To quit the external DB connection wizard without saving the changes click «Cancel» (Fig. 7.6—6).

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

Fig. 7.6—7 External Plates dadabase parameters

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

External Plates database connection is completed.