At 07:29 AM 8/04/2005 -0400, you wrote:

>How do I connect to an embedded firebird database using isql?
>
>This works fine when superserver is running...
>
> isql "myfile.fdb" -user sysdba -p masterkey

It's not connecting to an embedded firebird database. You want isql to
access your database by connecting through your embedded server, right?
Just copy isql.exe into your appdir (where fbclient.dll, your renamed
fbembed.dll, is) and run it there (local connection only). Same story
with gbak, gstat, gfix.

You need a proper path spec for the database, of course (or an alias).

My appdir here is k:\Firebird\Embedded, where firebird.conf, firebird.msg,
aliases.conf and all binaries are located.

Here's a paste from my command window:

K:\firebird\Embedded>isql "c:\Program
Files\Firebird\Firebird_1_5\examples\employee.fdb"
Database: c:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb
SQL> show tables;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT EMPLOYEE_TXT
JOB PHONE_LIST
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES
SQL> exit;

K:\firebird\Embedded>gbak -b "c:\Program
Files\Firebird\Firebird_1_5\examples\employee.fdb"
k:\Firebird\Embedded\employee.fbk

However, in aliases.conf I have:

emp = c:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb

So this works, too:

K:\firebird\Embedded>isql emp
Database: emp
SQL> show tables;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT EMPLOYEE_TXT
JOB PHONE_LIST
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES
SQL> exit;

./hb