Subject RE: [firebird-support] Checking Ods version (2.5 <-> 3.0)
Author Ralf Jansen
Post date 2016-05-12T18:57:19Z
No Server involved. I am directly using the fbembed/fbclient.dll for for connecting to an fdb file. 
I'm a Firebird embedded user.


From: firebird-support@yahoogroups.com [firebird-support@yahoogroups.com]
Sent: Thursday, May 12, 2016 20:18
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

 

Hi,
 
This detection is useless .
use the latest library (FB3) and you can connect to any older servers
 
regards,
Karol Bieniaszewski
 
Sent: Thursday, May 12, 2016 6:50 PM
Subject: RE: [firebird-support] Checking Ods version (2.5 <-> 3.0)
 
 

I missed to say that it’s all about embedded usage. So before executing any statement I would need to know what firebird library to use for connecting.

My use case is actually detecting pre ODS 12 databases and doing a backup/restore to get them into the current format.

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Donnerstag, 12. Mai 2016 17:30
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

 

Hi,

i do not know what do you mean “to check”

Can you connect to db? or you cannot and need to check?

If you can connect, then this is simple:

SELECT r.MON$ODS_MAJOR, r.MON$ODS_MINOR

FROM MON$DATABASE r

regards,

Karol Bieniaszewski

Sent: Thursday, May 12, 2016 4:02 PM

Subject: [firebird-support] Checking Ods version (2.5 <-> 3.0)

 

Hi,
is there an easy/official way to check the ODS versions?
I was going the gstat route but the 2.5 gstat doesn't know anything about ODS 12 and up and the 3.0 gstat only knows about ODS 12 and up.
Both gstats throw errors in case of an unknown ODS Version but it feels wrong relying on that error message for distinction.

Thanks
Ralf