Subject Re: [firebird-support] Is the embedded version right for me?
Author Bjorkman
Post date 2014-01-12T22:00:06Z
Thanks for quick response and to do a backup to send over if needed.

I have downloaded flamerobin and installed it but I can't open my embedded firebird DB...

So far I have copied all files for my embedded db into my development directory and renamed the dll to FBCLIENT.DLL
In flamerobin I rightclick on localhost and select Create New Database
For teh path I have tried to
- put the path to my dev-dir; or
- browse there and select teh FBCLIENT.DLL file ( I don't have a FDB-file yet)
Authentication - Use trusted user authentication
Charset - tried a couple including none

I Click create and always get a message:


What am I missing ...

From: Ray Cote <rgacote@...>
To: firebird-support@yahoogroups.com
Sent: Sunday, January 12, 2014 2:43 PM
Subject: Re: [firebird-support] Is the embedded version right for me?

 
----- Original Message -----
From: "Lester Caine" <lester@...>
To: firebird-support@yahoogroups.com
Sent: Sunday, January 12, 2014 1:54:32 PM
Subject: Re: [firebird-support] Is the embedded version right for me?

Bjorkman wrote:
>
>
> Hello,
> I currently have a java application using another database as an embedded db.
> I'm looking for replacement.
>
> The benefits of current db:
>
> 1) Embedded (just copying files into proper directory at install)
For the software to run it - yes just copy firebird files

> 2) My install use a DB already setup with tables and some initial values
> 3) If a client has problems with the SW they can send the db (4 files) to me and
> I can test with their DB in my develop environment.
> 4) If I find a problem with the DB I can update and send back to them
The database is a single file. While one can simply copy it, it makes more sense
to use the backup and restore functions to compress the data and rebuild indexes
when restoring.
My own systems use a database per website which gets automatically backed up
each night - something which can be run while the site is live! - and then
copied to the storage area for duplicating to another machine.

I'll second the suggestion to use backup the file before sending it to you.
Backups can be done while the system is live.
Copying the file while the software is running leads to potentially corrupt data files.

> 5) There is a good GUI SQL Browser with the project to work with the DB (setting
> up tables, running sql-script files, adding users, etc.)
http://www.flamerobin.org/ except users are not used for the embedded server,
they form part of a full server which has it's own user database.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

--
Ray Cote, President Appropriate Solutions, Inc.
We Build Software
www.AppropriateSolutions.com 603.924.6079