Stack Overflow
Stack Overflow

Questions tagged [firebird-3.0]

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

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

Notable new features

  • Unified executable
  • Improved SMP support for SuperServer
  • Encrypted wire protocol
  • Per-database configuration
  • Multiple security databases
  • Improved SQL user management
  • BOOLEAN data type
  • IDENTITY support
  • PSQL packages
  • PSQL functions
  • DDL triggers
  • SQL Window (or analytical) functions

Resources

See also

174 questions
3
votes
1 answer

How to create user for Firebird database

Downloaded Firebird database Firebird-3.0.3.32900-0_x64_pdb.zip. Extract folder install_service.bat and able to access EMPLOYEE.FDB database. Also able to access EMPLOYEE.FDB database without install_service. For creating new user for EMPLOYEE.FDB,…
Hkachhia
  • 4,130
  • 5
  • 35
  • 71
3
votes
1 answer

Firebird 3.0 Encryption with AES128 plugin - Unable to connect

I'm using Firebird 3 with encryption via the AES128 plugin found here. https://www.ibphoenix.com/products/software/encryptionplugin I have successfully encrypted the database, and I am able to connect and query it using isql however I am not able…
Phil
  • 3,779
  • 3
  • 51
  • 94
3
votes
1 answer

Table drops not actually done by Firebird until application closed

I have a .net test application which creates table, uses them, then drops them, many times. When I run this application against a Firebird 3.0.2 database with Firebird ADO.Net Data Provider 5.9.1, it fails at soon as it has to create a table with…
Frédéric
  • 8,372
  • 2
  • 51
  • 102
3
votes
1 answer

How to create "GENERATED BY DEFAULT AS IDENTITY" field in Firebird 3 via SQLAlchemy?

I want create column ID via SQLAlchemy. SQL seems like: CREATE TABLE OBJECT ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, NAME VARCHAR(15) ) Or how to create table with autoincrement field? …
Евгений
  • 31
  • 5
3
votes
3 answers

Counting entries depending on foreign key

I have 2 tables, let's call them T_FATHER and T_CHILD, where each father can have multiple childs, like so: T_FATHER -------------------------- ID - BIGINT, from Generator T_CHILD ------------------------------- ID - BIGINT, from…
Sebastian Proske
  • 7,985
  • 2
  • 26
  • 36
3
votes
1 answer

How to run firebird as an application?

I have downloaded ZIP file and unpacked it. Now, it is said, that FB can run as an application. How to run it this way? Running firebird.exe does nothing. I don't want to install it as a service.
Dims
  • 37,353
  • 77
  • 251
  • 478
3
votes
1 answer

Select from execute block?

Is is possible to select from execute block result? I want to perform some operation (sum etc..) from it. select t1.* from ( execute block returns ( OUT_VALUE integer ) as begin ... suspend; end ) t1 or…
Steve88
  • 2,035
  • 3
  • 19
  • 40
3
votes
1 answer

Unable to connect Firebird 3.0 embedded version

I have tried to connect to Firebird database file using IBExpert and Flamerobin always got this error "Unable to complete network request to localhost" Is there any changes in Firebird 3.0 with embedded version, because I can connect to version…
PHP4PRO
  • 121
  • 2
  • 5
3
votes
1 answer

How to correctly migrate from Firebird 2.5.1 to Firebird 3.0?

I'am trying to migrate Firebird 2.5.1 to Firebird 3.0 What is done: Back up on Firebird 2.5.1 Restore on Firebird 3 The problem is that not all tables were migrated; procedures, triggers and views are not recovered. Why? Is anywhere manual how to…
May12
  • 2,090
  • 11
  • 49
  • 91
3
votes
1 answer

How to use a transaction parameter block with the Firebird 3 OO Api

I've been playing with the new Firebird.pas interface included with Firebird 3. I'm having an issue when I try to use a custom transaction parameter block. I seem to always get the error "invalid format for transaction parameter block" if I add…
MarkF
  • 1,586
  • 1
  • 13
  • 25
3
votes
1 answer

Does Firebird ADO.NET 4.10.0.0 Data provider work with Firebird 3.0?

I'm currently trying to get my ASP.net 4.5 project connecting to the recently release Firebird 3.0. I'm using Visual Studio 2015 Community edition, Firebird 3 (64 bit), and used NuGet to get the ADO.NET 4.10.0.0. However, when I try to connect, I…
CSharpNewb
  • 141
  • 1
  • 14
3
votes
2 answers

Firebird Create function TRANSLATE as in Oracle

I try to create a function with the same functionality as the TRANSLATE function in Oracle, I have created function in Oracle and it works good but I have a problem when I try rewrite this code to Firebird. I get an error that 'expression evaluation…
Tomasz Dębski
  • 183
  • 1
  • 2
  • 8
2
votes
1 answer

Firebird connection string not working post Firebird 3 migration

I have a regression with a TCP\IP connection string post a firebird 3 migration from v2.5. The FirebirdClient version is 4.6.1 but I've tested with the latest stable version and it also doesn't work (v7.10.1). The error message is "Your user name…
Netstrata
  • 23
  • 4
2
votes
2 answers

How to get sum of detail table fields in master table with update trigger

There are master table 'factgad' and detail table 'recgad' in a Firebird 3.0 database. factgad: factgad_k(pr_k)... recgad: recgad_k(pr_k), factgad_k(fk)... When I update the master table, I have to get sum of detail table's records, but I couldn't…
basti
  • 167
  • 9
2
votes
1 answer

I can log into a Firebird 3 database with any user and password

In a newly created database, I don't get any error message when I log in with the wrong user and password (the users TTT and AAA don't even exist) [root@fewww bin]# ./isql /opt/db/treewww/ftree.db -user ttt -password bbb; Database:…
Haik Hairapetyan
  • 23
  • 3
1
2
3
…
11 12