---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