get version number of running firebird service?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

get version number of running firebird service?

Post by Bjarke_Moholt » 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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: get version number of running firebird service?

Post by ViktorV » Thu 24 Dec 2015 10:05

Please clarify, why using of the TIBCConnection.DatabaseInfo.FBVersion property is not suitable for you?

Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

Re: get version number of running firebird service?

Post by Bjarke_Moholt » Thu 14 Jan 2016 10:05

ViktorV wrote:Please clarify, why using of the TIBCConnection.DatabaseInfo.FBVersion property is not suitable for you?
I've experienced a situation where the TIBCConnection.DatabaseInfo.FBVersion shows some unexpected results.

I ran the following test scenario:
1) uninstall current firebird service
2) install firebird service x
3) run a small application in which I establish an IBCConnection and verify the FBVersion.

Here's where it gets hairy: On the computer I used the FBVersion was not shown to be service x as expected, but the old, now uninstalled, service. I concluded that something was out of order and contacted you.
I've now done the same test on a different computer and everything seems to be in order, so I went back to the original machine and verified the unexpected behaviour. Then I uninstalled FB altogether and tried running the application, yielding the expected 'unavailable database' exception. After reinstalling FB version x, the FBVersion showed the correct firebird version..

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: get version number of running firebird service?

Post by ViktorV » Fri 15 Jan 2016 11:20

We are glad to see that the issue resolved. Please contact us if any further questions concerning IBDAC usage come up.

Post Reply