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