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
0
votes
1 answer

Job for firebird3.0.service failed because a configured resource limit was exceeded

Error when install and after when try to start Firebird 3.0 Service. Job for firebird3.0.service failed because a configured resource limit was exceeded. See "systemctl status firebird3.0.service" and "journalctl -xe" for details. invoke-rc.d:…
Wellington1993
  • 194
  • 1
  • 2
  • 15
0
votes
1 answer

Cannot connect to Firebird 3.0 using ODBC

I have installed Firebird 3.0 (Firebird-3.0.0.32483_2_x64) under Windows 7 (64 bit). I have created a Firebird database using ISQL and want to copy data to it from a Microsoft Access database. I have installed the Firebird ODBC driver…
Mike B
  • 1
  • 3
0
votes
1 answer

Firebird and Hibernate - How do you specify a DB role?

I'm working in a new project to convert our Delphi + Firebird system to Java 8 / JavaFX / JPA (Hibernate) and Firebird. We are using the latest version of Jaybird and connecting to Firebird 1.5, Firebird 3.0 and InterBase XE3 databases. I have not…
David Culbertson
  • 1
  • 2
0
votes
1 answer

How to update records based on values from another table?

I use Firebird 3.0 and I have 3 tables: Table1: tbl1_id (PK), f2_id (FK), tbl1_f1 tbl1_f2 is a foreign key to table2 Table2: f2_id (PK), f3_id (FK) f3_id is a foreign key to table3 Table3: f3_id (PK), tbl3_code Now I need to set Table1.tbl1_f1…
William
  • 3,692
  • 10
  • 50
  • 101
0
votes
0 answers

undefined symbol: ib_util_malloc when trying to call a UDF

I created a very simple UDF, compiles fine but when I try to use it, it gives the following error: root@chii:/data/database/bot# /opt/firebird/bin/isql chii.fdb Database: chii.fdb, User: SYSDBA SQL> select YKUDF_PERLWRAPPER('/bin/ls' , '-al') from…
Sophia
  • 82
  • 10
0
votes
1 answer

Entity Framework migration script not working with firebirdsql

I'm using EF Migrations with a Firebirdsql Database and it works fine just fine while I update databases using the PackageManagerConsole in VS. If I use Update-Database -Script and then try to run the script I get an error. After a bit of testing I…
MaLKaV_eS
  • 1,415
  • 3
  • 21
  • 33
0
votes
0 answers

How to use Oracle code in Firebird

Oracle's alter session set nls_date_format = 'DD-Mon-YYYY', how do i use that in firebird? I tried casting but it does not work and extract and I can't get it work.
Anna
  • 1
  • 1
0
votes
1 answer

Firebird ADO.NET provider 5.0.5.0 to Firebird 3.0 can not connect except sysdba

I am trying connect to firebird 3.0 throught latest version of ADO.NET provider 5.0.5.0 from my simple test .net application. When i used sysdba user connection is made OK, but if i used other user then connection failed with classic FBException :…
Majkl
  • 767
  • 1
  • 8
  • 24
-2
votes
1 answer

Firebird database BLOB type with 20,000 bytes, which SQL Server data type to store blob?

Migrating data from a Firebird database to SQL Server. There is a BLOB Binary field which has values around 20,000 bytes which was measured using OCTET_LENGTH function. Which SQL Server data type will house more than 8000 bytes?
Dan
  • 1,391
  • 3
  • 11
  • 29
1 2 3
…
11
12