Subject Re: [firebird-support] isql: how to connect to embedded server
Author Alexandre Benson Smith
Em 8/12/2010 21:38, Adrian Grajdeanu escreveu:
> All I'm trying is to open up the fdb without going through a server. How do I do
> that? I don't care whether it is called embedded server or regular fb client.
> I'm not quite sure what the difference is anyway, except that fb client can
> (should) go through any flavor of servers: embedded or not.

It's not a matter of how it's called, but wich archtecture do you use :)

regular firebird client will connect to a firebird server, the embedded
server is the server itself packed oon a DLL, so it runs in the
application space.

The embedded server is available to download in a zip kit separated from
the regular Client Server instalation.

I don't understand your phrase "All I'm trying is to open up the fdb
without going through a server".

do you mean:
1.) I don't want a network connection to another computer
2.) I don't want a server (service) running on the local computer
3.) I wish an easy instalation/distribution to access a database from a
single application (tipical mono-user application). Note. FB 2.5 allows
more than one process to access the same database at once.

Embedded server is used for the scenario #3

> So basically: how do I connect isql to a local fdb, without going through a
> service bound server?
> Thanx.
> A.

You could access a local fdb using a regular client/server approach
using the loopback interface or the local connection. Embedded will
provide "direct" access the the file with an embedded server in your

If you want to use the embedded server download the zip kit (there are
more detailed instructions on the zip kit), but in a simple way.. just
rename fbembedded.dll to fbclient.dll or gds32.dll and put it in the
same path as you executable (or isql if you wish to use it).

> ________________________________
> From: Alexandre Benson Smith<iblist@...>
> To:
> Sent: Wed, December 8, 2010 6:19:58 PM
> Subject: Re: [firebird-support] isql: how to connect to embedded server
> Em 8/12/2010 18:59, adriangrajdeanu escreveu:
>> Hi,
>> I've created an app from which I create a 'test.fdb' using user 'alpha' pwd
>> 'beta'. Now I want to look at 'test.fdb' using isql and I am unsuccessful.
>> Seems that I can only connect isql _iff_ the windows service is running and as
>> 'SYSDBA'. Alas, I can't connect as as user 'alpha'. Nor do I want to. I want to
>> connect as user 'alpha', just as my app will, and see just what my app will see.
>> If I stop the service, I can't even connect as 'SYSDBA'. What am I missing?
>> My db is in W:\Fb-Data\test.fdb, my Firebird installation is in "C:\Program
>> Files\Firebird\Firebird_2_5"
>> I've tried from the fdb directory like so:
>> W:\FB-Data>"c:\Program Files\Firebird\Firebird_2_5\bin\isql.exe" -U alpha -P
>> beta test.fdb
>> Statement failed, SQLSTATE = 08001
>> unavailable database
>> Use CONNECT or CREATE DATABASE to specify a database
>> SQL>
>> BTW, tested with ' and with " around user and pwd, same failure.
>> Then I've tried from the isql dir like so:
>> c:\Program Files\Firebird\Firebird_2_5\bin>isql -U alpha -P beta
>> W:\FB-Data\test.fdb
>> Statement failed, SQLSTATE = 08001
>> unavailable database
>> Use CONNECT or CREATE DATABASE to specify a database
>> SQL>
>> Again, tried with ' and " around user/pwd, same failure.
>> I've tried as SYSDBA/masterkey in both scenarios, still failure.
>> I've copied dlls and isql.exe and firebird.msg in same dir with fdb, same
>> failures. I've copied dbclient.dll into fbembed.dll and gdb32.dll, still
>> failure.
>> So, is it possible at all to use isql to connect to a fdb via an embedded
>> server? Programatically I had to specify ServerType=Embedded (not precise syntax
>> shown), but if that is what I need, how do I do it to isql?
>> Thanx,
>> Adrian
> Perhaps I didn't understand you correctly... but are you sure you are
> using the Enbedded server and not then regular fb client ???