The Error Table

ADS also keeps track of errors it encounters in a special DBF table named ads_err.dbf. The configuration of ADS specifies where this table is stored. To discover the location of this file, use the following steps:

1. Open the Advantage Data Architect.

2. Select Tools | Advantage Database Server Management.

3. Set Server Drive to the drive or share where the server is running. Use a UNC (universal naming convention) path if the server is running on another machine on your network. Click the Connect to Server button, which appears to the immediate right of the Server Drive field.

4. Once connected, click the Configuration Parameters tab, then click the Not Affecting Memory tag. The Error Log and Assert Log Path field displays the location where the ads_err.dbf file is stored.

Use the Advantage Data Architect to view this free DBF table, as described in the following steps:

1. From the Advantage Data Architect’s main menu, select File | Open Table.

2. Set Path to the location where the ads_err.dbf file is stored.

3. Set Files to ads_err.dbf or use the Browse button to select the file.

4. Set Table Type to DBF/CDX.

5. Select the server type. Remember, all Advantage applications that are opening a single table (in this case, ads_err.dbf) should be using the same server type. Otherwise, 7008 errors are likely to occur. In other words, all applications that want to open the same table concurrently should either all be using ALS or all be using ADS to open that table.

6. Click OK.

Once you select the ads_err.dbf file, all errors that have been saved can be viewed. The most recent errors appear at the end of this table.