ETL and Data Integration tools - Modern ETL software for everyone

Hello, I'm trying to open sakila-sample-database-ports for Firebird in FlameRobin, but it seems to me it takes password and login, anyone know login and password for INTERBASE-SAKILA.FDB ?

Thanks in advance.

Database has no user name/password

Firebird server does

Default one is

SYSDBA/masterkey

Mike

Thanks Mike.

Of course I tried to use SYSDBA/masterkey but I got message:

---------------------Begin message-----------------------------

*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed

SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code : 335544344
Engine Message :
I/O error for file "/home/sergei/FirebirdDemoDB/interbase-sakila-db/INTERBASE-SAKILA.FDB"
Error while trying to open file
Permission denied

--------------------------End message-----------------------------------

My OS XUBUNTU 10.04, sample from Firebird distribution works OK.

Is it possibly something goes wrong with sakila-sample-database-ports chaset settings?

Is it possibly something goes wrong with sakila-sample-database-ports chaset settings?

May be it is the case.

Another thing you can try is to create brand new database ans run scripts provided.

Mike

May be it is the case.

Another thing you can try is to create brand new database ans run scripts provided.

Mike

Thanks Mike.

I tried to create new database in iqsl-fb using script interbase-sakila-schema.sql but I got a lot of errors, so I tried to track every line in script and got forst error on

CREATE TABLE customer (
customer_id INT NOT NULL,
store_id INT NOT NULL,
first_name VARCHAR(45) NOT NULL,
last_name VARCHAR(45) NOT NULL,
email VARCHAR(50) DEFAULT NULL,
address_id INT NOT NULL,
active CHAR(1) DEFAULT 'Y' NOT NULL,
create_date TIMESTAMP NOT NULL,
last_update TIMESTAMP NOT NULL,
PRIMARY KEY (customer_id),
CONSTRAINT fk_customer_address FOREIGN KEY (address_id) REFERENCES address (address_id) ON DELETE NO ACTION ON UPDATE CASCADE
);

I got message:


SQL> CREATE TABLE customer (
CON> customer_id INT NOT NULL,
CON> store_id INT NOT NULL,
CON> first_name VARCHAR(45) NOT NULL,
CON> last_name VARCHAR(45) NOT NULL,
CON> email VARCHAR(50) DEFAULT NULL,
CON> address_id INT NOT NULL,
CON> active CHAR(1) DEFAULT 'Y' NOT NULL,
CON> create_date DATE NOT NULL,
CON> last_update DATE NOT NULL,
CON> PRIMARY KEY (customer_id),
CON> CONSTRAINT fk_customer_address FOREIGN KEY (address_id) REFERENCES address (address_id) ON DELETE NO ACTION ON UPDATE CASCADE
CON> );
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 8, column 3
-active


So I guess sakila-sample for firebird has internal defect.

I launched isql-fb with dialect 3.

Works fine for me

ACTIVE one of the keywords

www.firebirdsql.org/file/documentation/r...-in-25-reswords.html

it all depends on the version of course...

It did not fail when I run it

Anyway can you try putting active in double quotes "active"

Mike