Connecting the external database

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).
   
3. Click the Configuration button to open the Configuration window.

4. Click the Configure… button in the appeared window (1).
   

   Note.

   If the Auto-Intellect PC database shold be used as the external database click Local DB (2) and go on to step 6.

   Note.

   If the external database is the Auto-Intellect PC database then you can add numbers with the help of Vehicle Plate Search program (see Creating the Active tracking database section in the reference manual Auto Intellect software package: Operator's guide).

5. 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:
   5.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 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:

   Attnetion!

   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.

   
   5.3.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.
   5.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 data source name field (1).

   Note.

   Oracle database name is entered upon its installation.

   
   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 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 it is necessary to click OK.
   

   
   

   
   5.3.6 To complete the connection to external Oracle database click OK.

6. After selecting the database (see step 5) in the External DB connection wizard window there will be displayed connection string with the selected database (1).
   
7. In the Table list (2) the names of tables in the selected database are displayed. Select the table, containing vehicle plates from the list.
8. In the Field list (3) the names of columns on the selected table are displayed. Select from this list the column with vehicle plates.

9. Click OK (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.

10. The Connecting string, Table and Field fields on the External plates database settings panel will be filled in result of performing the operation (1) .
    
11. Click Apply (2).

External Plates database connection is completed.