Hi All:

Well, I've tried to connect to the employee.fbd with no luck so far:

Here is an abstract of what I did:

START>RUN>

C:\Program Files\Firebird\Firebird_1_5\bin\isql.exe

Brings up the sql window prompt:

I entered:

CONNECT "C:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb" then
I hit enter

CON> did come up and I entered

user 'SYSDBA' password 'masterkey'; and hit enter

I got a dynamic error -104 error token line 1 userSQL>

First the user parameter is on line 2 isn't it?

Second, someone on another list told me to enter command mode by entering
cmd but I don't think I should do that from within a program like isql.exe.

I tried cmd at the run prompt but just got the message that C:\Programs was
not a program or executable file.

After a few permutations of everything my screen reader, or the run window
itself, became wierd. I couldn't delete lines of code nor get any commands
to work so I Re-Bootted and wrote this help message.

Any ideas of what I might be doing wrong?

I'm going to ask on the BlindProgramming list about using command lines
also. I've avoided them in the past as my screen reader doesn't work well at
all with command line mode. Perhaps there is someone on that list who can
help in this respect.

Thanks for any ideas or pointers.

Rick USA

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, April 13, 2006 9:22 AM
Subject: Re: [firebird-support] Connect to Sample FDB


> At 10:25 PM 13/04/2006, you 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.
>
> It's not specific to Windows - the username and password belong to
> the firebird server, whatever host it is running on. Use SYSDBA and
> masterke for now.
>
>
>>Step ONE:
>>
>>I went to the bin directory and clicked ISQL.exe:
>>
>>The SQL window came up and I entered:
>>
>>quit;
>>
>>the window closed.
>
> Lucky, but actually you need to run the command-line utilities
> directly from the - well - command line, i.e. open a command shell
> from Start > Run. Tip: make a shortcut that takes you straight there
> (I call mine "Command-in-bin").
>
>>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';#
>
> Yes. Except, if you are using Classic you need to connect through
> the localhost server:
>
> SQL> CONNECT "localhost: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
>
> No, not Administrator - unless you create a DB server user named
> Administrator. But until you get your head around SQL privileges,
> stick with SYSDBA.
>
>>Is there a way to check My User Id and Password for a Fb DataBase on
>>Windows
>>XP?
>
> Username - yes, once you have successfully logged in.
>
> select cast(current_user as varchar(31)) from rdb$database;
>
> Password -no. Even the SYSDBA can't retrieve anyone's password. If
> don't have a good memory, you'll need to keep paper records of passwords.
>
>
>>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.
>
> Definitely for later research. SQL privileges are a nest of
> (eventually necessary) vipers.
>
>
>>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.
>
> You verify the password for the supplied user name by submitting a
> connection request. If it fails, you know that you have one of them
> wrong.
>
>
>>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?
>
> Sure. Remember, ISQL is just a client application. Theoretically,
> if you can connect to your server installation using ISQL, you can
> use the same connection parameters to connect from any
> application. Where it gets interesting is that different drivers
> have their own ways of playing about with the connection
> parameters. ODBC (which I understand you are planning to use with
> Liberty Basic) is no exception to this rule.
>
> ./heLen
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>