Subject | Connect to Sample FDB |
---|---|
Author | Richard Thomas |
Post date | 2006-04-13T12:25:54Z |
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
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