Subject Re: Database works fine but phsical storage file is not exist. How ?
Author omurolmez
Yes you are right. But I searched for abc.*. I can not find.

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
>
> 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
>