Applies To:
  • CitectSCADA 5.xx, 6.XX
  • CitectHMI 5.xx, 6.XX
Summary:
Windows XP Service Pack 2 upgrades the existing MDAC to MDAC 2.8 as part of the installation. In this version, various changes have been made to the Jet engine when going through the Borland Data Engine (BDE) and this can cause issues when multiple applications are using ODBC to get access to Dbase files. This has been found on German Windows XP with Service Pack 2 installed. 
 

Solution:
Microsoft recommends that ISAM (Indexed Sequential Access Method) be used instead of the BDE. This can be achieved via a registry setting forcing all Jet access via ODBC to occur via ISAM as opposed to BDE. The following is the registry entry required:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Xbase]
"BDE"=dword:00000002

(WARNING: You should only change registry settings with care, incorrect settings can corrupt your Windows installation).
Keywords:
odbc dbf SP2  

Attachments