--- In firebird-support@yahoogroups.com, "Richard Thomas"
<rthomas@...> wrote:

>
> Good Morning Gang:
>
> Today I'd like to connect to the Employees sample Db and play with

it some:

>
> Here is my general plan with a couple of basic questions.
>
> The only real question is how I verify the User and Password for the
> database in Windows XP but sometimes assuming anything when learning

can

> cause headaches so here is the plan with a couple of embedded questions.
>
> Step ONE:
>
> I went to the bin directory and clicked ISQL.exe:
>
> The SQL window came up and I entered:
>
> quit;
>
> the window closed.
>
> it's working.
>
> Step Two:
>
> connect to the
>
> "C:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb"
>
> DataBase.
>
> The Connect Statement:
>
> SQL>
>
> CONNECT "C:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb"#
>
> CON>
>
> user 'SYSDBA' password 'masterkey';#
>
> Rick:
>
> From Quick Start:
>
> user:
>
> Administrator was mentioned as user for windows so:
>
> SYSDBA or Administrator
>
> Also:
>
> Is there a way to check My User Id and Password for a Fb DataBase on

Windows

> XP?
>
> Rick: Blurb in Quick Start:
>
> if Firebird runs as this user)
>
> needs also to have permissions to objects
>
> inside a database.
>
> Rick: don't fully understand, later research if not required to play

with

> Employees DB to verify today's connection.
>
> We will look at authenticating as SYSDBA using the password masterkey.
>
> Rick This is why I'd like to verify the User and Password before

hitting

> enter.
>
> At this point, isql will inform you that you are connected:
>
> DATABASE "C:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb",
>
> User: sysdba
>
> SQL>
>
> You can now continue to play about with the employee.fdb database. The
> characters
>
> To get back to the command prompt type
>
> SQL>QUIT;#
>
> EndOfPlan:
>
> If everything works, meaning I can use the command line Input and

Output for

> experimentation, I'll dig into the manual to explore other interactive
> commands and utilities before trying to connect from within a

Liberty Basic

> program. .
>
> Does this plan sound OK?
>
> Thanks for any pointers:
>
> Rick USA
>

Rick,

I don't know your setup of the Firebird installation, but my earliest
trouble started because the quick start guide is not clear enough for
me that for classic server on localhost with local database dirve, you
still need the host name before you can connect to the database file:

SQL>connect "localhost:c:\firebird\examples\employee.fdb"

have fun!

jml