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

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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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
'masterkey';
SQL> create table a(f1 VARCHAR(10));
SQL> show tables;
A
SQL> insert into a(f1) values('123');
SQL> select * from a;

F1
==========
123

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;

F1
==========
123

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 http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links