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 ???