Adam wrote:

Is there any way of determining the ODS of a database for pre 11.1 ODS (from a client connection, not gstat)? Specifically, I need to know whether a given database was built with Firebird 1.5 or 2.1.

In Firebird 2.1/ ODS 11.1, I can run:

select mon$ods_major||'.'||mon$ods_Minor as ODS
from mon$database;

but the monitoring tables obviously don't exist in older versions. If not, I can work around it by catching the exception.

Helen Borrie answers:

Not via DSQL. Use the isc_info_ods_version and isc_info_ods_minor_version items in a isc_database_info() request.

Or if you just want a remotable utility to do it interactively, SHOW DATABASE in isql.

Like this post? Share on: TwitterFacebookEmail

Related Articles


Firebird Community



Gems from Firebird Support list