Stack Overflow
Stack Overflow

Questions tagged [firebird]

Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

3372 questions
9
votes
3 answers

How to use GROUP BY in firebird

The structure of T_TABLE2 is ID INT TBL1_ID INT TESTER VARCHAR LOT_ID VARCHAR GRP VARCHAR SITE_NUM INT TEST_NUM VARCHAR TEST_DESC VARCHAR MEASUREMENT DOUBLE PRECISION UNIT VARCHAR LL DOUBLE PRECISION UL DOUBLE PRECISION STATUS VARCHAR and I use SQL…
aiipee
  • 252
  • 2
  • 6
  • 18
9
votes
1 answer

How to check in which server mode (e.g. SuperClassic or Superserver) a Firebird database is running?

The latest Firebird 2.5.x database can run in either Classic, SuperClassic, or SuperServer mode. How can I check in which of these modes an installed database is running?
Jan Derk
  • 1,563
  • 18
  • 18
9
votes
5 answers

Firebird x Windows 7 x gds32.dll error

I have a fdb file (firebird) from a new client (he doesn't know the version). I have tried to use some GUI to access the database, but with no luck. All of them tell that its missing gds32.dll, but I have this one. I have copied this dll to the GUI…
Olivertech
  • 557
  • 2
  • 4
  • 19
9
votes
5 answers

experiences with firebird server over the internet with multiple clients?

Has somebody real experience with firebird databases over the internet? I have a typical windows accounting/ERP software (done with delphi) that works with the firebird database server pretty well.. Now my users (300 aprox. now, but should…
pragmatic_programmer
  • 3,138
  • 2
  • 23
  • 34
8
votes
2 answers

NHibernate with Firebird... are these features enabled?

We're using NHibernate to great success with a Firebird backend. My question relates to the features available in NHibernate being supported by Firebird. If you have any expertise with Firebird and NHibernate your comments are welcome. Does…
Kotarsi
  • 81
  • 2
8
votes
4 answers

How do I use transactions in Firebird?

In MS SQL Server, I can easily put multiple insert statements into a transaction, like so: begin tran insert into mytable values (1, 2, 3) insert into mytable values (4, 5, 6) commit tran I'm trying to do the same thing in Firebird, but I can't…
Mason Wheeler
  • 77,748
  • 42
  • 247
  • 453
8
votes
3 answers

Firebird backup restore is frustrating, is there a way to avoid it?

I am using Firebird, but lately the database grows really seriously. There is really a lot of delete statements running, as well update/inserts, and the database file size grows really fast. After tons of deleting records the database size doesn't…
Yordan Yanakiev
  • 2,366
  • 3
  • 35
  • 82
8
votes
2 answers

Executing a script using ISQL

I'm creating a simple isql script but it's not working and I need some help to find out whats wrong with it. I need to connect to a database and execute a SQL file. This is my script called script.sql: CONNECT…
user729661
  • 81
  • 1
  • 1
  • 2
8
votes
3 answers

Why we haven't boolean datatype in Firebird?

Unless I'm totally wrong, we have no boolean datatype (1 bit) in Firebird, even SQL Server. Why? I think boolean usefull in various situations... And very low space consuption...
Alex
  • 3,209
  • 10
  • 47
  • 75
8
votes
1 answer

Simple Firebird query very slow

I have a table with roughly 246k records. It has about 25 columns, all are integers except one small blob. If I Query the table on all fields select a.recordid, a.editcount, ect.. from ARTrans a It executes in under a second. But if I include only…
cjmarques
  • 481
  • 6
  • 13
8
votes
2 answers

Convert character set from ISO8859_1 to UTF8

I have a database in firebird 2.5 filled with data. I need to change the character set from UTF-8 to ISO8859_1, I tried: alter database default character set ISO8859_1 collation ES_ES But it doesn't work. Thanks 4 help!
Quiron
  • 310
  • 2
  • 11
8
votes
1 answer

Is it possible to know the level from the last incremental backup, made with nbackup from Firebird?

It's a pretty straightforward question. Firebird has a backup tool called nbackup whereas you can make incremental backups. The tool complains if you don't make the backup in the correct order (e.g. you make a level 0 backup, then a level 2). Then,…
user1492491
8
votes
3 answers

DataTable.Load(FbDataReader) does not load everything into DataTable

There is a closely related question here: .NET DataTable skips rows on Load(DataReader) I have a SQL Query that returns 169 results. The result looks like this: CustomerID Customer Name TerminalID Creation Date 1 First Customer 12345 …
waka
  • 2,988
  • 9
  • 31
  • 45
8
votes
2 answers

Can't connect to local Firebird with ISQL

I'm trying to setup a local firebird instance to test against but am unable to connect to it with even ISQL. I have tried to following by following the quick start guide here: CONNECT ..\examples\empbuild\employee.fdb user SYSDBA password…
Luke Chamberlain
  • 400
  • 2
  • 4
  • 14
8
votes
3 answers

Firebird: Unable to complete network request to host

I'm trying to connect to a remote Firebird database "test" (alias already added). It is not an embedded server, and is installed on VM with IP 192.168.1.147. Here is my connection…
Colt
  • 134
  • 1
  • 1
  • 6
1 2 3
…
99 100