7008 Advantage server file open failure

Advantage Error Guide

Problem 1: The specified table, memo file, or index file was unable to be opened.

Solution 1: Verify the following:

 

Problem 2: This error can occur when the connection to the Advantage Data Dictionary was made using a local-drive-letter path and tables within the dictionary are not on the same drive. Advantage stores the file path of the table relative to the data dictionary file in the data dictionary. If the file path of the table cannot be converted to a relative path, this error is returned.

Solution 2: Open the Advantage Data Dictionary using UNC or through a network drive (the network drive will be converted to UNC). This allows the tables and indexes to be located on a different drive then the one the data dictionary is on. Note that the files must be accessible using a UNC path (i.e., the must be on a share).

 

Problem 3: This error can occur when making a connection or opening a table from inside a server-side module (such as an extended procedure or a trigger) on a Windows server and using a drive letter. Services cannot resolve a drive letter to a local path, which can lead to a 7008 error.

Solution 3: Use UNC (\\SERVERNAME\SHARE) when making connections or opening tables from inside a server-side module. Also use UNC for any TDataSet aliases that are used from inside a server-side module.

 

Problem 4: This error can occur if you have a trigger on the table you are trying to open, or if you have a trigger that uses the table you are trying to open.

Solution 4: Triggers often cache the statement they use to execute the trigger code. If this cached statement references the table you are trying to open exclusively, you can get a 7008 error. All users who have modified the table with the trigger need to close the table (the table the trigger is defined on) before you can gain exclusive access to ANY table modified inside the trigger.