Applies To:
  • CitectSCADA 5.xx
  • CitectHMI 5.xx
Summary:
When starting Citect, I get the error "an unexpected exception has been encountered while accessing your project databases."

ODBC return code: -1

Error description: The database engine could not lock table 'MASTER#DBF' because it is already in use by another person or process.

ODBC error string: State:S1000,Native:-1304, Origin:[Microsoft][ODBC dBase Driver]"

 

Solution:
In KB Article Q2321 it had a similar error message with the resolution being to delete odbc*.* files in the windows directory and that this error only occurred with non-English versions of windows. This problem has occurred a number of times on computers at our site and it is because Office 97 was installed before Citect on Windows 95 computers. I tried this fix a number of times, reinstalling Citect after deleting the files, without success until I noticed that the odbc files weren't being copied during the Citect installation. So this error was now because there were no odbc files. I copied the odbc files from another computer that runs Citect and now Citect runs without a problem.

Running the CitectDB installation from the CitectDB directory on the installation CD will also reinstall the ODBC drivers.

The same ODBC installation can be downloaded from the Toolbox on the website, however, this is a 12Megbyte download.

 
Keywords:
 

Attachments