community.borland.com

Article #28142: InterBase 6.5 on Windows XP

Windows XP System Restore

Definition:
"makes it easier to resolve problems if they occur in your system. You can use System Restore to remove any system changes that were made since the last time you remember your computer working correctly..."

(Full Article: Use System Restore to Undo Changes if Problems Occur)

Problem:
Unfortunately Windows XP Professional does a backup of the default InterBase file extension 'GDB'. Every time a file with the *.gdb file extension is attached to and modified it is automatically getting backed up by XP.

Workaround:

  1. Turn off system restore.
    1. Go to "Start"
    2. Right click on "My Computer"
    3. Select "Properties"
    4. Select the "Restore" tab
    5. Check the "Turn off System Restore on all drives" box
  2. Install InterBase on it's own hard drive or partition and turn off Restore on the drive.
    1. Go to "Start"
    2. Right click on "My Computer"
    3. Select "Properties"
    4. Select the "Restore" tab
    5. In "Drive settings" area select the drive you installed InterBase.
    6. Select the "Settings..." button
    7. Check "Turn off System Restore on this drive"
  3. Make isc4.gdb read only and don't use new *.gdb files.
    1. Run "gfix -mode read_only"
    2. Please note: This will disable gsec and other utilities from making security changes. You will have to use "gfix -mode read_write" to modify isc4.gdb.
    3. Our open source community has found a possible workaround by editing its FileList.xml file that lists file extension to be restored. This file is located in c:windowssystemrestore on most systems. However this workaround is not recommended and may infringe on licensing issues on your operating system.

     
    Fast User Switching

    Definition:
    "Fast User Switching is a new feature in Windows XP that leverages the data separation technology of Windows NTŪ profiles and provides a fast and convenient mechanism for switching between user accounts."

    (Full article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwxp/html/winxpfus.asp)

    Problem:
    In our current release, InterBase must be installed by a member of the Administrator group and only allows users of this group to work when "Fast User Switching" is enabled.

    Workaround:

    The only know workaround for this is to not use "Fast User Switching".

    Last Modified: 08-JAN-02