Using an InterBase 7.5 database with InterBase 7.x fails

By: Quinn Wildman

Abstract: InterBase 7.5 introduces a new ODS (11.2) and databases created or just touched by InterBase 7.5 may not be used with InterBase 7.0 or 7.1.

Q. I'm using InterBase 7.0 or 7.1 and when I try to use or create a database I get the error:

Statement failed, SQLCODE = -902

internal gds software consistency check (decompression overran buffer (179), file: sqz.c line: 222)

What does this mean?

A. This error occurs when InterBase 7.0 or 7.1 attempts to use a database created or touched by InterBase 7.5. If you need to use such a database with InterBase 7.1 you must back it up with InterBase 7.5 and then restore it with the version of InterBase you are using first.

Note that the security database (admin.ib by default) falls into this category as well. Uninstall/Install does not touch this file, so if you uninstall InterBase 7.5 and install InterBase 7.0 or 7.1 to the same location, you will have a security database that is unusable by InterBase 7.0/7.1. This will cause all databases to fail opening and not allow new databases to be created as well. To correct the problem rename or delete your security database and reinstall InterBase.

Note that backing up a database causes the ODS to change as well. So, if you backup a 7.1/7.0 database with InterBase 7.5, the source database will no longer be usable by InterBase 7.1/7.0. You will have to restore the database with InterBase 7.1/7.0 to use it with that version.

Server Response from: ETNASC03