An open-source DBMS platform descended from Interbase.

learn more… | top users | synonyms

0
votes
1answer
17 views

How to GRANT/REVOKE user permissions for user on Firebird 1.5?

I need to create a user in firebird 1.5 and give him permissions to access only some specific tables. I have managed to create the user, but apparently GRANT/REVOKE operations only work on version 2.1 ...
0
votes
0answers
70 views

Firebird Guardian

Is there an opinion on running Firebird Guardian. According to the FAQ - The Firebird FAQ: On Windows, having guardian running can even be counter-productive as it would run fbserver.exe ...
2
votes
1answer
43 views

Join more than 3 tables in one single query, with many comparisons and no IDs

I use an overlycomplex and poorly designed software at my work, and now I need to produce a report of invoices issued between a period of time. Invoices are held at table ENTR2012, which uses the ...
1
vote
1answer
12 views

Firebird Index Creation Fails

I'm creating an index in a table with the following command: CREATE INDEX IDX_CVE_OBS ON FACTF01 (CVE_OBS); But it returns me the following error: this operation is not defined for system tables. ...
0
votes
0answers
44 views

Firebird linked tables in Access 2010

I have multiple data sources in multiple databases that I have been tasked with correlating for business analytics. I currently have ODBC connections to two (one Pervasive, one Firebird) that I can ...
1
vote
0answers
27 views

ExecuteNonQuery struck and control never come back to next line in vb.net with firebird

I am using vb.net with firebird 2.5. I have a grid which has 100,000 records have to insert/update in the database but as I run loop it stuck in ExecuteNonQuery statement. few lines work but after ...
0
votes
1answer
63 views

How to stop Firebird SuperClassic (run as application) in Win 7?

I run Firebird 2.5.3 SuperClassic as application in Windows 7 64-bit with this command: fb_inet_server -a -m Now, how can I stop/shutdown it from command prompt? I know that I could right-click its ...
1
vote
0answers
66 views

Can't restart or stop Firebird 1.5 on linux

I have an ubuntu server running firebird 1.5. It was working fine, but recently it started hanging (firebird does not respond anymore). Even when trying to restart or stop the server, it shows an ...
1
vote
1answer
877 views

Firebird 2.5. Windows 8.1. Can't connect to any database! Why?

I'm trying to use a FireBird database engine. OS: Windows 8.1 x64(SmartScreen enabled, UAC enabled, Custom AntiVirus installed(with firewall)) FireBird: Version 2.5, Installed as SuperServer, as ...
1
vote
0answers
95 views

firebird update very slow

I am writing a stored procedure for Firebird 2.5 in which I sometimes need to update a single row in a data table more than once in the same transaction. However, I have noticed that the performance ...
2
votes
1answer
76 views

adjecency list model vs nested sets

I've stumbled upon an article describing nested sets model for storing hierarchical data and was quite intrigued by the supposed performance boost. after implementing this in our database, i've found ...
1
vote
1answer
124 views

How to deploy case-insensitive embedded firebird database?

I'm trying to find out how to create CI firebird embedded database. I've found (here) that there are some character sets each of them has one or many collations. So, UTF8 has UCS_BASIC, UNICODE and ...
1
vote
1answer
917 views

Using ODBC Connection to Access Firebird Database

I have an ODBC connection to a Firebird database that tests successfully. Is there a way to use this ODBC connection within SQL Server 2008 R2 to access the tables? I haven't used Linked Servers ...
0
votes
0answers
88 views

How does the optimizer of Firebird determine join order?

As Most query optimizers determine join order via a dynamic programming algorithm pioneered by IBM's System R database project, I was wondering whether the optimizer of Firebird uses the same ...
2
votes
0answers
247 views

Firebird2.5 error with collation in POSITION

Why does the following query succeed in Firebird 2.1, but fail in Firebird 2.5? select POSITION(_UNICODE_FSS 'alcu' IN _UNICODE_FSS 'Calculation') from "Election" The error is Error: *** ...
1
vote
2answers
1k views

Why do I get this error?

When ever I try to connect with Firebird SQL I get this error, firebird$ isql-fb 'db.FDB' -u SYSDBA -p <PASS> Statement failed, SQLSTATE = 08001 I/O error during "open" operation for file ...
0
votes
1answer
618 views

row_number over partition at Version < Firebird 3

I´m currently at the end. Given facts: ID ID2 FROM TO COSTS 4985 501671 2013-07-25 00:00:00 2013-12-30 00:00:00 17.8 4985 501671 2013-09-05 00:00:00 ...
2
votes
0answers
37 views

Set default fields

Is there a way to inform the database that some fields are default (have always the same value) so that I don't need include them in all my queries? Suppose: Select ... where f1=a, f2=b, f3=c, f4=d ...
1
vote
1answer
189 views

Firebird query performance with text search, also some numbers

I have situation as follows: I'm having a table OFERTY of 10k+ records, and when I select * from it, I get PLAN (OFERTY NATURAL) Executing... Done. 656 fetches, 0 marks, 0 reads, 0 writes. 0 inserts, ...
1
vote
1answer
127 views

Set up Firebird with shared storage?

I am new to firebird and confused with SuperServer SuperClassic thing. But what i wonder is how should i set up this scenario on Linux? Single shared storage that store database file on SAN 4 ...
1
vote
1answer
215 views

What is the difference between Interbase and Firebird?

I'm interested in a broad overview of how they are diverging and why.
1
vote
2answers
499 views

Is it possible to Install two (2) Firebird instances of different names & ports (gds_db port 3050 & fbsvc port 3051) running as service?

Is it possible to Install two (2) Firebird instances of different names & ports (gds_db port 3050 & fbsvc port 3051) running as service !? I mean the two running as service not application ...
1
vote
1answer
295 views

Firebird database recovery and protection

I'm sure many companies are running critical Firebird database servers in production 24/7. Other than regular backups, what backup/recovery/protection techniques are available? I am also interested in ...
0
votes
1answer
186 views

sort a large table by its primary key and save it back

So I have a large table (>50 million rows) with an auto incremented primary key column, which is filled by a script running on multiple cores. Now, when I do a SELECT, entries are returned 'out of ...
1
vote
2answers
956 views

Improve performance with the WHERE NOT IN sub-select clause

In the following query, I have to count transactions for each customer. [EDIT]However, I have to exclude from the result set entirely, customers that have a transaction older than one year. ...
2
votes
1answer
129 views

Minimizing Page Fetches

I have a complicated database structure and am trying to use it to retrieve Records based on multiple selection criteria from several tables. As a general rule, is it better to attempt to use ...
1
vote
0answers
228 views

Firebird database performance after server upgrade/restart

Got a 350 GB database (more than 40M records plus 0 - 1000 BLOBs for each record in another table). After upgrading Firebird to version 2.1.5 (mainly because of filesystem cache issue) database became ...
1
vote
1answer
993 views

how to set a column to fetch the date now?

hi i have a sample table named datenow and used the following to create my table on flamerobin to have a column that gets the date today automatically when an entry is added. CREATE TABLE "DATENOW" ( ...
2
votes
1answer
180 views

how to build table relationships in a firebird database?

I am a beginner in Delphi and I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following ...
1
vote
1answer
2k views

How do I check if a constraint exists on Firebird?

I'm about to publish a script which will update a lot of Firebird databases all at once. Some will not have this constraint, so I would like to check for the existence of a constraint before I try to ...
1
vote
2answers
430 views

Storing a transaction sensitive constant in Firebird

I'd like to store a number in my Firebird database that indicates the revision of its structure. The number is supposed to be updated only when the structure has successfully been altered by some ...
4
votes
1answer
3k views

Firebird monitoring tables

I am working with a Firebird 2.1.1 database and I started reading about the Monitoring tables. I am trying to see somehow in real-time what queries does each client performs in the database. I had ...
6
votes
1answer
3k views

Fixing corrupted Firebird database

I have a 200 GB Firebird database (created with Firebird 2.1.3, currently running 2.1.5), and it appears to be corrupted. When I try to do a backup I get: database file appears corrupt <> ...
8
votes
2answers
250 views

Minimizing Indexed Reads with Complex Criteria

I'm optimizing a Firebird 2.5 database of work tickets. They're stored in a table declared as such: CREATE TABLE TICKETS ( TICKET_ID id PRIMARY KEY, JOB_ID id, ACTION_ID id, STATUS str256 ...
6
votes
3answers
893 views

Creating an index in both asc and desc directions

Over the past few weeks I've been raging against an old Firebird database. This database is crappy for all sorts of reasons, but one thing I noticed was that every single field of every single table ...
5
votes
2answers
3k views

No luck trying out Firebird 3.0

Today I though I'd give Firebird 3.0 a shot, but for some reason I can't seem to get it installed - at least not in a way that I can connect from a JDBC application. What I did was to follow this ...
13
votes
1answer
276 views

Term for a one-row table?

Is there a specific term to describe a relation with a cardinality of one? I'm thinking particularly of RDBMS "special" one-row tables, for example, DUAL (Oracle), SYSIBM.SYSDUMMY1 (DB2, Derby) and ...