--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> > 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
>
> have you tried:
> SQL> connect "C:\Program Files\...\examples\EMPLOYEE.FDB" user larryl
> password the_password;
> Alan
>

Thanks Alan:

That worked.

I didn't realize the placment of the user and login was
so strict. I thought once I specifed my user and password,
I would be set to connect to any DB I owned.

Thanks
Larry