Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.

Previous page Connecting to the main database of the Intellect system  Selecting an SQL database and setting up its parameters Next page


This section describes the connection to an Access database as the main Intellect database.

To connect to an Access database, open the Data Link Properties window. To set the main database in the Access format, do the following:

  1. Select the Microsoft Jet 4.0 OLE DB Provider line in the Provider tab and click the Next button or move to the Connection tab.
  2. Select or enter the pathname of the database file in the Select or Enter a Database Name field of the Connection tab. To enter the pathname, do one of the following:
    1. manually enter the pathname;
    2. Click the … button to open the standard dialog box for file selection.
    3. To connect to the main Access database located on the remote computer, the pathname should have the following format:
      \\<IP address (or name) of the computerð\\Intellect\Data\intellect.mdb.
  3. Test the connection to the database. To do this, click the Test Connection button.
  4. The information box with the text Test connection succeeded will appear in case of successful connection.

  5. An information box with the error description will appear in case of a connection error.

    Example:

     If an invalid database address has been supplied, the following warning will open:

    Note.

    In case of connection error, check the connection parameters in the Provider and Connection tabs.
  6. In case of a successful test, confirm the database change by clicking the OK button.

This completes the selection of the main database in Access format. The information from the selected database is now loaded into the Report system.

  • No labels