'[Pervasive] [ODBC Client Interface] [LNA] [Pervasive] [ODBC Engine Interface] Unable to open table: tablename'
Solution ID:
00015187
Problem Description
PDB_KB_Problem
When attempting to drop a table from the Pervasive Control Center, the following error message is received: ''[Pervasive] [ODBC Client Interface] [LNA] [Pervasive] [ODBC Engine Interface] Unable to open table: tablename''
''[Pervasive] [ODBC Client Interface] [LNA] [Pervasive] [ODBC Engine Interface] Unable to open table: tablename''
Problem Environment
PDB_KB_Environment
Pervasive.SQL 2000
Cause of the Problem
PDB_KB_Cause
This results from trying to drop a table definition from the Pervasive Control Center after deleting or renaming the actual physical file (the data file) associated with the table definition.
Solution Notes
PDB_KB_Solution
The table is still seen in the Pervasive Control Center because it is still defined to the Data Dictionary Files (DDFs). You may use the
''Drop Table'' wizard to delete the table definition so that it will not display in the Pervasive Control Center. To avoid the error message, simply
remove the checkmark for ''Delete Data File''.
Published: June 2002_
Rating
![1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.]()
![2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.]()
![3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.]()
![4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.]()
![5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.]()