Re: [firebird-support] Re: server version

2013-02-05 Thread Mark Rotteveel
On Mon, 4 Feb 2013 17:11:08 -0500, Ann Harrison aharri...@ibphoenix.com wrote: On Sun, Feb 3, 2013 at 7:25 PM, Paul Vinkenoog p...@vinkenoog.nl wrote: That works - if the difference between 1.0 and 1.5.6 doesn't matter to you - but the OP wanted a solution that didn't require opening a

Re: [firebird-support] Re: server version

2013-02-04 Thread Mark Rotteveel
On Mon, 04 Feb 2013 08:09:44 +0800, Wolfgang Kluge wkl...@kb-labuan.com wrote: Good morning Paul I am using Try Qry.Close; Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version 2

Re: [firebird-support] Re: server version

2013-02-04 Thread Ann Harrison
On Sun, Feb 3, 2013 at 7:25 PM, Paul Vinkenoog p...@vinkenoog.nl wrote: That works - if the difference between 1.0 and 1.5.6 doesn't matter to you - but the OP wanted a solution that didn't require opening a database connection first (and as we now know, he needs it for JDBC). That's a

Re: [firebird-support] Re: server version

2013-02-04 Thread Paul Vinkenoog
Ann Harrison wrote: That works - if the difference between 1.0 and 1.5.6 doesn't matter to you - but the OP wanted a solution that didn't require opening a database connection first (and as we now know, he needs it for JDBC). That's a little like wanting to know the color of your prize

[firebird-support] Re: server version

2013-02-03 Thread hugo.larson
Hello Paul, Thanks for your answer. What I want to do is to determine server version from pure JDBC. I probably posted this question in the wrong group. Should have posted it in Firebird-Java group. BR, Hugo --- In firebird-support@yahoogroups.com, Paul Vinkenoog wrote: Hello Hugo, Is

[firebird-support] Re: server version

2013-02-03 Thread petr.jicin
Is there a way to determine which version of Firebird is running before connection to a Database? I'm looking in org.firebirdsql.management but cant find anything fitting. Or using Python and fdb library (python binding): import fdb svc =

Re: [firebird-support] Re: server version

2013-02-03 Thread Wolfgang Kluge
Good morning Paul I am using Try Qry.Close; Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version 2 Qry.ExecQuery; cEngineVer := Qry.FieldByName( 'cVer' ).AsString; Qry.Close;

Re: [firebird-support] Re: server version

2013-02-03 Thread Paul Vinkenoog
Hi Wolfgang, I am using Try Qry.Close; Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version 2 Qry.ExecQuery; cEngineVer := Qry.FieldByName( 'cVer' ).AsString; Qry.Close;