firebird

How to connect and use Firebird db embedded server with Visual C# 2010

Hi all I was trying to use Firebird embedded server with Microsoft Visual C# 2010. so here is what I done till now: 1- Downloaded Firebird .Net Data Provider (Firebird Client v2.5.2). 2- Downloaded Firebird Embedded server (Firebird Embedded Server v2.5.0). 3- Added a reference to FirebirdSql.Data.FirebirdClient.dll to my project. 4-...

insert row without set primary column

I have that query : INSERT INTO GOST (ASSORTMENTID, ROZMIAR, GOST) VALUES ( 54,'S','MjgwMzktODkgMTc0LTk2') I want insert new row in table GOST, but I don't want to specify column with primary key - GOSTID. I want that database set next id value. When I run this code I have that error: validation error for column GOSTID, value "...

FireBird adding dropping constraint

In Firebird I want to generate the scripts for adding all the constraints in a database and also I want to generate the script for dropping all the foreign key constraints. How do I do this? ...

Is FireBird still alive?

I am looking for some embedded databases. SQLite has some issues with the GUI. What about FireBird? How active is it's mailing list and forums? Does it follow all the rules of ANSI SQL? Is it suitable for production? ...