Subject RE: [firebird-support] How to identify database created by Firebird 1.5 or Interbase 6.5?
Author Thomas Steinmaurer
> Interbase 6.0.2's ODS is 10.0. Firebird 1.0.3's ODS is 10.0.
> Basically we can treat both the databases are same can may exchange
> the server to access it without any problem. However, I found that
> Interbase 6.5 and Firebird 1.5.1 has same ODS 10.1 and Interbase 7.1
> is using ODS 11.
> My problem is how am I going to identify database created by IB 6.5
> or Firebird 1.5.1? Both type of database has same ODS but it seems
> like both database do not same identical structure as stated by
> Craig Stuntz [TeamB] on 2002-07-23 07:47:01 PST:
> In article <3d3c8139$1_1@dnews>, tony.caduto@... says...
> > I don't think they changed the ODS for 1.0, they are going to
> change it for
> > 1.5 and 2.0
> >
> This is wrong. They changed the ODS (probably to support the 8 KB
> pages). Firebird reports ODS 10.1. IB 6.5 also reports 10.1, but
> the
> Firebird "10.1" is not the same as the IB 6.5 10.1.

The minor ODS upgrade in Firebird 1.5 means that there are
additional indices on specific system tables.

From the WhatsNew.txt document:

* Minor ODS upgrade.
Added new system indices (RDB$INDEX_41, RDB$INDEX_42, RDB$INDEX_43), now ODS version is 10.1.
Dmitry Yemanov <yemanov at>,
Nickolay Samofatov <skidder at>

So, you could execute the following system table query:

rdb$index_name = 'RDB$INDEX_41' and rdb$relation_name = 'RDB$INDICES'

If this returns one record then it is ODS 10.1 of Firebird 1.5.

Just a thought.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions