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.

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



________________________________
From: Alexandre Benson Smith <iblist@...>
To: firebird-support@yahoogroups.com
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 ???







[Non-text portions of this message have been removed]