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;
Except
cEngineVer := '1.5.6'; // default if engine version >=2 cannot be
verified
End;

Regards
Wolfgang Kluge

On 02/03/2013 08:30 PM, hugo.larson wrote:
>
> 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
> <mailto:firebird-support%40yahoogroups.com>, Paul Vinkenoog wrote:
> >
> > Hello Hugo,
> >
> > > Is there a way to determine which version of Firebird is running
> before connection to a Database?
> >
> > From within your application, you can connect to the Services
> Manager and then call isc_service_query(), specifying
> isc_info_svc_server_version in the request buffer. This is documented
> in the IB6 API Guide.
> >
> > Many clients (e.g. FlameRobin) can also give you this information
> without having to connect to a database first.
> >
> > Or, from the OS command prompt:
> >
> > > fbsvcmgr [hostname:]service_mgr -user -password -info_server_version
> >
> > This requires Firebird 2.1 or higher on the client machine.
> >
> >
> > Hope this helps,
> > Paul Vinkenoog
> >
>
>



[Non-text portions of this message have been removed]