Stack Overflow
Stack Overflow

Questions tagged [firebird-4.0]

For questions specific to Firebird 4.0. It is advisable to also tag with firebird.

Firebird 4.0 is the latest release of the Firebird database server.

Notable new features

  • Time zone support (TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE
  • Decimal floating points (DECFLOAT)
  • Increased maximum precision of NUMERIC and DECIMAL to 38 digits
  • Introduction of INT128 (128 bit integer)
  • Increased identifier length to 63 characters
  • Asynchronous and synchronous replication
  • Lateral derived tables
  • Built-in functions for encryption and cryptographic hashes
  • Built-in functions for encoding and decoding Base64 and hex
  • Extensive system privileges and ability to assign automatic roles
  • Engine and database configuration (read-only) exposed through virtual table RDB$CONFIG
  • Batch execution of statements
  • ... and a lot more, see Firebird 4.0 Release Notes

Resources

See also

18 questions
3
votes
1 answer

How to grant usage on generator syntax

I'm usually not the one working with Firebird language, but I have to fix access to generators in order to continue working. There is one line in my script: set generator order_gen to 0 that doesn't work anymore. I'm trying: GRANT USAGE ON GENERATOR…
MHeydt
  • 135
  • 8
3
votes
3 answers

Migrate Firebird 2.5 to 4.0 using ADO.Net provider

I just upgraded my DB to Firebird 4.0 and all seems to work when connecting to the DB using a database management tool. So now I try to connect, after making sure I've upgarded my ADO.Net to FirebirdSql.Data.FirebirdClient v8.0.1 (latest). Here is…
neggenbe
  • 1,697
  • 2
  • 24
  • 62
2
votes
1 answer

Firebird 4 Get "Incompatible data type" error when using gsec or isql

I'm facing an issue when I try to use gsec or isql on v4.0.1: # "${PREFIX}"/bin/gsec -database "security.db" -display MYUSER Incompatible data type Or via isql: # "${PREFIX}"/bin/isql -user sysdba security.db Database: security.db, User:…
ebelair
  • 844
  • 11
  • 27
2
votes
1 answer

Convert column domain as smallint to boolean in firebird

I'm using Firebird 4.0 and I would convert a column from smallint 0|1 to boolean. So I have this kind of domain: CREATE DOMAIN D_BOOL AS SMALLINT DEFAULT 0 NOT NULL CHECK (VALUE IN (0,1)) ; This domain is used in my test table: CREATE TABLE…
ebelair
  • 844
  • 11
  • 27
2
votes
1 answer

How retrieve CHAR and VARCHAR field definitions depending on Firebird database encoding

In Firebird (4.0), I get the field length with following query: SELECT T.RDB$RELATION_NAME, RF.RDB$FIELD_NAME, RF.RDB$NULL_FLAG, F.RDB$FIELD_TYPE, F.RDB$FIELD_LENGTH FROM RDB$RELATIONS T, RDB$RELATION_FIELDS RF, RDB$FIELDS F WHERE…
neggenbe
  • 1,697
  • 2
  • 24
  • 62
1
vote
0 answers

Firebird 4 embedded in external folder

I created a "Firebird4x32" folder in which I have all the necessary files to access the Firebird database in embedded mode. If I copy the content to the root directory of the application (e.g. D:\app), the database is loaded and the application…
Jirka
  • 11
  • 2
1
vote
1 answer

How to connect FireDAC to Firebird 4 database without using a server (embedded mode)?

I would like to be able to connect my Delphi/FireDAC application directly to a Firebird 4 database file without installing the service. I expected to be able to do this by using the local protocol, and just specifying the file. However, I get the…
Jared Davison
  • 333
  • 3
  • 11
1
vote
1 answer

Delphi FireDac Firebird 4.0 Connection Pooling

I'm testing Firedac (Delphi 11 Update1) and Firebird 4.0 (Latest) for a rest API server project. I found the connection pooling technic in Firebird documentation as a possibility and also in FireDac documentation. In my test application, I can…
MrBG
  • 25
  • 1
  • 4
1
vote
0 answers

How can I install Firebird 4.0 version on Ubuntu?

I need to install Firebird 4.0 version on Ubuntu. When I installed Firebird like that: sudo apt-get install firebird-server I noticed that it was 3.0 version. Then I uninstalled it. How can I install 4.0 version on terminal?
sunShine
  • 41
  • 1
  • 9
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
0
votes
1 answer

Multiple different master-replication databases on one server

I would like to know if it is possible to have multiple different master-slave replications on a single Firebird server. That is, several masters on a Firebird server, replicating to their corresponding replicas on another server. file -…
matheuswww
  • 1
  • 1
0
votes
1 answer

Cannot use IBExpert after updating to Firebird 4.0

IBExpert has a user database which stores all options. I made a FBK backup of this database using Firebird 2.5 which was my old level. I installed Firebird 4.0 and restored it. Now I have this database under both ODS levels (I believe that would be…
Paul
  • 5,700
  • 5
  • 43
  • 67
0
votes
0 answers

MS Visual Studio 2022 doesn't connect in Firebird 4

I migrated my Firebird 2.5 database to Firebird 4.0 and now I can not connect the MS Visual Studio 2022, I've tried several things but nothing works, someone has an idea how to solve this? I just keep getting the message: connection rejected by…
Marcos Corsato
  • 1
0
votes
1 answer

Firedac TFDEventAlerter and Firebird 4.0

I am trying to use the Firedac TFDEventAlerter in Delphi 10.4 to handle the events of a Firebird 4.0 database. Is that possible? With Firebird 2.5 it all works fine, but the same code in combination with Firebird 4.0 does not respond to the…
Dirk Janssens
  • 53
  • 5
1
2