CHIPS
and QRMS and File-Ease may have a compatibility conflict in their use of the
Borland Database Engine (BDE). When CHIPS is installed it installs the BDE on
each workstation, as do QRMS and File-Ease. There can be only one copy of the
BDE on a workstation, so whichever version of the BDE is installed last is the
one that is used. QRMS needs BDE version 4.5, File-Ease version 5.1 and neither
works with the older version CHIPS installs. Because the BDE is backward
compatible, CHIPS can use the BDE version 4.5 that QRMS installs and 5.1 that
File-Ease installs.
To
determine which version of the BDE is installed on a workstation:
From the Windows Start menu,
go to Settings | Control Panel, then launch the BDE Administrator control
panel.
In the BDE control panel,
select the Configuration tab. This will reveal a Configuration option in the
box below.
Expand the Configuration
option (click the + next to it), and then expand the Drivers and Native
options that appear below the Configuration option.
Below the Native option,
locate and select the Paradox entry.
On the main menu, select
Object, then Version Information.
In the form that appears,
find the entry for IDAPI32.DLL (in the first column). The second column
shows the version. If the number is 4.5 or higher (eg: 4.5.1.4), it is the
correct version for QRMS. If it is 5.1 or higher, it is the correct version
for File-Ease. If it is less than 4.5 it is the wrong version for QRMS and
the QRMS workstation install will need to be redone. If it is less than 5.1,
the File-ease install will need to be run again.
The
best way to avoid the conflict is to install CHIPS first, then install QRMS
and/or File-Ease. The QRMS workstation install will normally replace the older
CHIPS version of the BDE with its own version. In some cases the QRMS installer
will fail to replace the older BDE; in this case, follow the steps below to
resolve the conflict.
IMPORTANT NOTE:
The following procedures involve viewing and editing the information in the
Windows Registry. Editing the registry is inherently dangerous and can cause
your system to become unstable or unusable. If you are not comfortable doing
this, please have a qualified systems person perform these steps. QRMS is not
responsible for any lost or damaged information due to users following these
steps.
Steps
to work around different versions of the Borland Database Engine:
You will need to be logged on
to the workstation with an ID that has Workstation Administrator privileges
to do this procedure.
Install CHIPS on the
workstation.
Using the Windows Registry
Editor (RegEdit), open the Windows Registry for the workstation. If you
don’t know how to run RegEdit, you should ask a qualified system
administrator to do this procedure.
Backup the windows
registry. If you do not know how to do this, please consult a qualified
system administrator. QRMS is not responsible for any lost or damaged
information caused by users editing their Windows registry.
Determine
where the files for the Borland Database Engine are stored.
Using RegEdit go to:
Delete the entries in
the Windows Registry that pertain to the Borland Database Engine (NOTE:
Before doing this you should check whether any applications other than CHIPS
and QRMS installed on the workstation use the BDE. If they do, you should
review the version they use and the version QRMS installs to ensure there
are no conflicts. See the System Administration guide for complete details
on the Borland Database Engine version information.) To delete the BDE
entries, using RegEdit go to:
HKEY_LOCAL_MACHINE | SOFTWARE | Borland
Delete this entry (select the line in the left-hand box and press the Delete
key).
Delete the Borland
Database Engine files. Using Windows Explorer, go to the drive and
directory for the DLLPATH thatyou
recorded in step 4 above. Delete this directory.
Install the
Workstation portion of QRMS software, which will re-install the Borland
Database Engine and create new entries in the Windows Registry.
Using the steps
above, check that the correct BDE version is now installed.
Run CHIPS and ensure
that it is working correctly.
Run QRMS and ensure
that it is working correctly.
QRMS_File-Ease
and CHIPS BDE Compatibility_Rev3.doc
QRMS reserves the right to change the information in this document
at any time without notification.
