Hi Folks:

I've been looking through 150 threads that dealt with this
problem, but I can't see what I'm doing wrong.

OS - Windows 2K
FB installed from - Firebird-1.5.3.4870-0-Win32.exe
FB running as - Superserver
Install options - Application, not server - Don't start FB at
boot.

The first task was to change the sys

C:\Program Files\...\bin>gsec -user sysdba -password masterkey
GSEC> modify sysdba -pw the_password
GSEC> add larryl -pw the_password
GSEC> display
user name uid gid full name
----------------------------------------------------------------
SYSDBA 0 0
LARRYL 0 0
GSEC>

Now I try to run ISQL against the sample EMPLOYEE.FDB.

Use CONNECT or CREATE DATABASE to specify a database
SQL> user 'larryl' password 'the_password';
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect "C:\Program Files\...\examples\EMPLOYEE.FDB";
Statement failed, SQLCODE = -902

Next I try to set user to sysdba:

SQL> user 'sysdba' password 'the_password';

fbserver.exe and fbguard.exe are both running.

I'm running the Win2K session under the user name of "larryl",
if that matters.

I haven't setup ISC_USER and ISC_PASSWORD envrionmental variables
because I don't know how. Is that my problem? Can someone tell me
how to set environmental variables on Windows?

Thanks
Larry