First I think you should download the interbase docs from ibphoenix website
and take a look on it..

when you install firebird/interbase, there is an user (master user,
administrator, or any other name you can call it) that is "sysdba" the
password created for sysdba is "masterkey" (note the lower case in
password, and without the quotes of course). Something like user "sa"
password <blank> in MSSQL or user "scott" password "tigger" or user
"system" password "admin" in Oracle.

here are teh first steps to you, then you could create your first database
and table and populate then.


I think you should download some administrator tool for interbase (like
enterprise manager for MSSQL), there are some free, other commercials, you
choose...

Marathon is free and Open Source
QuickDesk is commercial there are others

let's take an example using ISQL that you already have...

when you run ISQL you have a CLI interface like this:

Use CONNECT or CREATE DATABASE to specify a database
SQL> create database "c:\data\xyz.gdb" user "sysdba" password "masterkey";
SQL> create table friend (FriendID integer not null, Name varchar(30),
phone varchar(30));
SQL> insert into friend (FriendID, Name, Phone) values (1, 'ABC', '123');
SQL> insert into friend (FriendID, Name, Phone) values (2, 'DEF', '456');
SQL> select * from friend;
SQL> commit;
SQL> select * from friend;
SQL> insert into friend (FriendID, Name, Phone) values (3, 'GHI', '789');
SQL> select * from friend;
SQL> rollback;
SQL> select * from friend;
SQL> exit;


now you have your first database with a table called friend on it.

Take a look in the docs and get and GUI tool that I think will help you in
your first step.


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - SP - BRAZIL
www.thorsoftware.com.br

At 09:49 16/11/2002 -0800, you wrote:

>Not sure how to start. I've downloaded the install
>routine and I've run it. FbSetup.EXE.
>
>I've also installed the ODBC driver.
>
>When I attempt to create a database, I get an error
>message:
>
>Use CONNECT or CREATE DATABASE to specify a database
>SQL> create database "test";
>Statement failed, SQLCODE = -902
>
>Your user name and password are not defined. Ask your database
>administrator to set up a Firebird login.
>SQL>
>
>I'm not sure what to do next. How do I define a user
>name and password?
>
>How do I use ODBC to connect to a database that is
>on another PC?
>
>Thanks in advance.
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/