Subject Re: [firebird-support] Database works fine but phsical storage file is not exist. How ?
Author Martijn Tonies

You specified no path AND no extension, why do you think Firebird
automatically creates "abc.fdb"?

Try searching for "abc" instead.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!

Versions of my binaries are :
Windows XP Home 2002 Tur(1254) SP3
fbserver.exe v2.0.3.12981
isql.exe v2.0.3.12981

I kept Firebird conf file as untouched.
I setup both Firebird Guardian and Firebird Server as service :
Startup type: automatic
Logon as: Local System account

I started isql.exe and create some objects as below:
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'localhost:abc' user 'SYSDBA' password
SQL> create table a(f1 VARCHAR(10));
SQL> show tables;
SQL> insert into a(f1) values('123');
SQL> select * from a;


SQL> commit;
SQL> quit;

I restart Windows(not hibernate, etc.). It restarted normally (no forced
termination of any process occured).

I started isql again :
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:abc' user 'SYSDBA' password 'masterkey';
Database: 'localhost:abc', User: SYSDBA
SQL> select * from a;


SQL> quit;

Now I can not find abc.fdb file in none of my local drives (I searched
hidden attr also).
So, where did firebird store my new database ?

Ömür Ölmez

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



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links