Subject Table Unknown Error
Author milesclark
Hi -

Just getting started with Firebird 1.0. I created several databases
(both in IBExpert & isql). These databases are inaccessible from both
IBAccess and the JCA-JDBC driver. The error returned is:

Dynamic SQL Error
SQL error code = -204
Table unknown

IBAccess complains that the RDB$RELATIONS table is missing. In the
case of the jdbc test, the actual user table I created is not found.

Below I include the sql to create the table. Any clues as to what's
going on?

create database 'javatest.gdb';
connect 'javatest.gdb';
commit;

create table MYUSERS (
id integer not null primary key,
name varchar(80)
);

insert into MYUSERS (id, name) values (1, 'mmc');
insert into MYUSERS (id, name) values (2, 'joe');
insert into MYUSERS (id, name) values (3, 'fred');
commit;


Thanks in advance!

Miles Clark