Re: [cobalt-developers] Interbase 6 SQL server & Cobalt

["Richard Abrams" <richard@xxxxxxxxxx>]

> Can anyone help with how to start the Interbase Server ???
>
> Many thanks,
>
> Steve Rogers

Try running ISQL using the following...

1. login using your admin account
2. use "su -" and your admin password to shell to root
3. type "cd /opt/interbase/bin"
4. type "./isql"
5. At the prompt to "CONNECT or CREATE database" type the following...

    a) create database '/home/sites/<yourpath>/<dbname>.gdb';
    b) connect /home/sites/<yourpath>/<dbname>.gdb;

6. this will create and connect to your database - make sure that the
quotation marks and semi-colons are all in the right place!!
7. Having completed this, you should then be able to build your database
using the following commands... (example)

create table customers
(
id            integer not null,
first_name    varchar(50),
last_name     varchar(50),
passwd        varchar(8),
status        char not null,
primary key(id)
)
;

insert into customers values
(
1,
'Richard',
'Abrams',
'password',
'A'
)
;

...other commands include:
"show tables;"
"show table <tablename>;"
"drop table <tablename>;"
"commit;"
and of course... "help;"!!

8. finally, set up your DSN in the ASP Management console - the username
should be "sysdba" and the password "masterkey".

Good luck :-)

        -Richard