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.
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.
Free Developer Edition!
Click here to download a free non-expiring Developer Edition or 30-day trial >
More InterBase Info
InterBase XE3 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase on Twitter
Server Response from: ETNASC04