Subject RE: [firebird-support] Another "Your user name and password are not defined" question.
Author Alan McDonald
> 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