You receive this error message while previewing the data of a DB Table variable if the corresponding table in the variable’s data source is not available at the moment.
When using a database as a variable’s data source, the problem typically occurs in the following cases:
-
The connection to the database that contains the specified table, view or query has been lost.
-
The selected table, view or query has been renamed or deleted from the database.
-
The specified database has been renamed or deleted.
When using an Excel workbook as a variable’s data source, the problem can be caused by the following:
-
The specified workbook is an Excel 2007, 2010 or 2013 file (.xls, .xlsx, .xlsm or .xlsb), but no appropriate data driver is installed on your computer. To read data from Excel 2007 - 2013 files, you must have Microsoft Office 12.0 Access Database Engine OLE DB Provider installed on your computer. See Microsoft Office Excel Data Connectivity for more details.
-
The selected sheet has been renamed or deleted from the workbook.
-
The specified Excel file has been renamed or deleted.
After you close the message box, you can select another table in the data source for the variable to provide access to. You can also return to the previous pages of the DB Table Variable wizard to select another data source or to instruct TestComplete to reload the list of tables available in the selected data source.
See Also
Variables of the DB Table Type
Add DB Table Variable Wizard
Edit DB Table Variable Value Wizard