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.