Subject | Re: [firebird-support] Database works fine but phsical storage file is not exist. How ? |
---|---|
Author | Martijn Tonies |
Post date | 2008-06-11T10:27:01Z |
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
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