Hi Thomas,

Thanks for the reply. If I follow your instruction, I can identity
if it is FB 1.5 database or FB 1.03 database.

But my problem is how to identity FB 1.5 database and Interbase 6.5
database since both database has same ODS 10.1. Do you mean the
Interbase 6.5 don't have the indices you mentioned?

--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> > 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@m... 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.

> Contributor(s):
> Dmitry Yemanov <yemanov at yandex.ru>,
> Nickolay Samofatov <skidder at bssys.com>
>
> So, you could execute the following system table query:
>
> select
> *
> from
> rdb$indices
> where
> 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
> http://www.upscene.com