Subject Re: [firebird-support] Re: Firebird 2.52 gbak fails to do a restore - error trigger (3)
Author
---In firebird-support@yahoogroups.com, <jackmason@...> wrote :
>
> Is this what you needed?
>

  Hmm... i'd say it is impossible to obtain such results using FIrebird. See below

> C:\Program Files\Firebird\Firebird_2_5\bin>isql -user sysdba
-pass masterkey
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> create database 'localhost:c:\temp\a.fdb';

Note, there is no error, i.e. database is created and isql have active connection

> SQL> show version;
> ISQL Version: WI-V2.5.2.26540 Firebird 2.5
> Server version:
> Cannot get server version without database connection

  Impossible... here shouild be present 3 lines with reports from engine, network server and
network client subsystems:

SQL> show version;
ISQL Version: WI-V2.5.5.26858 Firebird 2.5
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.5.26885 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.5.26885 Firebird 2.5/XNet (WIN7X64)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.5.26858 Firebird 2.5/XNet (WIN7X64)/P12"
on disk structure version 11.2

Instead, we have message about absent connection !


> SQL> connect 'localhost:c:\temp\a.fdb';
> Commit current transaction (y/n)?y
> Committing.

  It is expected - isql have active connection and active transaction and ask to commit it before
disconnect.

> Database:  'localhost:c:\temp\a.fdb', User: sysdba
>
SQL> show version;
>
ISQL Version: WI-V2.5.2.26540 Firebird 2.5
>
Server version:
>
Cannot get server version without database connection

  Same error...


  Could you run script below ?

isql -user sysdba -pass masterkey
create database 'localhost:c:\temp\a.fdb';
show version;
show database;
exit;

gstat -h c:\temp\a.fdb

Regards,
Vlad