get version number of running firebird service?
Posted: Tue 22 Dec 2015 09:54
We have experienced problems when using IBDAC components with FB 2.0 as described in http://forums.devart.com/viewtopic.php?f=24&t=30777, and see the need to upgrade to FB 2.5.
Upgrading on platforms hosting our application is easy enough, but connecting to databases on remote server locations uses the firebird service installed on the given server, not our host platform.
To address this issue we want a check on creation of the TIBCConnection object, getting the Firebird version used to enable the connection (the firebird version running at the location of the database). We have found the DatabaseInfo.FBVersion property on the connection but testing has shown this does not give us what we want. Is there a property that gives us what we need?
If all else fails, we can obtain one of the queries that would fail with older firebird versions and run it, but a more elegant solution would be preferable
Upgrading on platforms hosting our application is easy enough, but connecting to databases on remote server locations uses the firebird service installed on the given server, not our host platform.
To address this issue we want a check on creation of the TIBCConnection object, getting the Firebird version used to enable the connection (the firebird version running at the location of the database). We have found the DatabaseInfo.FBVersion property on the connection but testing has shown this does not give us what we want. Is there a property that gives us what we need?
If all else fails, we can obtain one of the queries that would fail with older firebird versions and run it, but a more elegant solution would be preferable