Subject | Database works fine but phsical storage file is not exist. How ? |
---|---|
Author | Ömür Ölmez |
Post date | 2008-06-11T10:10:51Z |
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]
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]