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

3750 questions
1
vote
1 answer

Problem with QIBASE (firebird + Ubuntu)

Good morning. I've tried to compile QIBASE driver to access FireBird database using sqlbrowser from %QTDIR/demos. But after i filled all fields in sqlbrowser and pushed OK button the program crashed with…
typbl4
  • 141
  • 8
1
vote
0 answers

How to connect laravel with Firebird database?

I'm trying to connect a Laravel 5.5 application to a Firebird 4.0 database, but I keep getting this error: PDOException: SQLSTATE[HY000] [335544721] Unable to complete network request to host I'm also using the jacquestvanzuydam\laravel-firebird…
Rogério Marcon
  • 23
  • 5
1
vote
1 answer

What to deploy for Firebird 4 clients?

Using Firebird 2, we had to deploy 3 files with our applications to be able to connect to remote firebird servers: fbclient.dll msvcr80.dll Microsoft.VC80.CRT.manifest The first file was retrieved from the "normal" Firebird installer, the other 2…
ralfiii
  • 584
  • 4
  • 13
1
vote
2 answers

Compare text file data with database records in C#

I have to make a select statement on a database and than compare the results with a text file using only C# in Visual Studio. If the text file has a bigger value than the record in the database, the program returns the value from the text file, and…
shade999
  • 79
  • 7
1
vote
1 answer

How to create default constraint on the table of Firebird to assign auto-generated UUID value

I am trying to define a table with a column type of UUID (CHAR(16) CHARACTER SET OCTETS). After reading through the Firebird 3.0 Developer's Guide, I found only context-variables/simple expression/constant are supported. I would like to know if…
Andrew
  • 17
  • 4
1
vote
0 answers

How to sensibly and efficiently expand a function without endless repetition

I'm trying to expand this function to cover all of our ten staff, but I realise I'm going about it stupidly. Curiously (to me!), the code allows me to copy and paste additional queries only once, i.e. for Dave, but if I copy the code block again, I…
daneee
  • 153
  • 8
1
vote
2 answers

How to extract digits from field using regex

I am using Firebird 2.5 and I have a field (called identifier) with mixed letters, numbers and special characters. I would like to use regex to extract only the numbers in a new column. I have tried something like below, but it is not working. Any…
Jonathan Livingston Seagull
  • 844
  • 10
  • 22
1
vote
1 answer

Database query returns minus number for one query and positive number for another - don't know why

Am using the below NODE js code to run a timeclock. For one specific user, and seemingly this is a problem that's only reared its head today, this particular user (OPID 7) is being told he's worked minus time, whereas other users are shown their…
daneee
  • 153
  • 8
1
vote
1 answer

How to use parameters (e.g. for Firebird) in the SQL statement (optional) that defines ODBC data source for Power BI Desktop

I am trying to define ODBC data source for Power BI Destop and use parameters in it. So - I have ODBC DSN for the Firebird (defined in the "ODBC Data Source Administrator (64-bit)") and I can successfully import full tables from this ODBC in the…
TomR
  • 2,696
  • 6
  • 34
  • 87
1
vote
0 answers

How to read Firebird 1.5 database with PHP 8.0?

How to read Firebird 1.5 database with PHP 8 on Linux? I have uncommented pdo_firebird extension in php.ini and restarted php8.0-fpm, but when checking modules with php -m, I'm getting the following error: $ php -m …
DevonDahon
  • 7,460
  • 6
  • 69
  • 114
1
vote
1 answer

Firebird 2.5 query returns COLLATION UTF8_CI_AI_NUMERIC_SORT for CHARACTER SET UTF8 is not installed

I have an old source database in which apparently custom collation UTF8_CI_AI_NUMERIC_SORT was created. I'm running it on docker via image jacobalberty/firebird:2.5-ss. Originally database was created on a Windows machine. When I try to do a query…
DekiChan
  • 375
  • 1
  • 4
  • 14
1
vote
1 answer

Multiple queries with Firebird and PHP 7.3

It's my first time working with Firebird database and I need some help in the transactions department. I need to run multiple functions inside a ''main function'', those functions have queries, but if one fails, I need them all to rollback. Can I…
BRABO
  • 100
  • 7
1
vote
1 answer

error: no permission for select access to view

I have a Firebird 3 database. I created a new user, NATO. Then I created a new role, Cash. On database tables this role has permissions. Query, that contains these tables, works fine, but when I create view (v_goods) from these tables, it has no…
basti
  • 399
  • 2
  • 10
1
vote
1 answer

Loop with SQL insert not removing spaces

I have a situation where I created a loop to makes multiple inserts. However, white space is giving an error when making the SQL statement. Example below: The code below works query <- "INSERT INTO TBPPRODU (TBPCODIGO,PROCODIGO) VALUES…
Jonathan Livingston Seagull
  • 844
  • 10
  • 22
1
vote
1 answer

Entity Framework 4 + Firebird -> Freezing on Fetch if there is other transaction open

The problem is as folows: If i am editing a row in IBExpert and dont commit the transaction, the EF just freeze when trying to fetch Data ( Entity.ToList() ). I Would understand if that happened when trying to update the row, but why does the EF…
Rafael Reis
  • 11
  • 1
1 2 3
…
99 100