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

Incompatible wire encryption levels requested on client and server with Firebird ado.net provider

I am testing the connection firebird 3 using C #. The version of what I'm used is the latest : Firebird ADO.NET Provider 5.0. But when you make the connection , the error occurs "Incompatible wire encryption levels requested on client and server"."…
Marcoscdoni
  • 893
  • 1
  • 7
  • 26
10
votes
3 answers

"connection rejected by remote interface" connecting to Firebird 3 with PDO

Try code below, but cause exception - SQLSTATE[HY000] [335544421] connection rejected by remote interface: try { $dbh = new PDO("firebird:dbname=localhost/3050:empty", "SYSDBA", "masterkey"); $dbh->setAttribute(PDO::ATTR_ERRMODE,…
Vladimir Z.
  • 648
  • 3
  • 11
  • 29
9
votes
2 answers

How change a column type in firebird3

Since firebird 3 I can't modify a column type Before I use this kind of update : update RDB$RELATION_FIELDS set RDB$FIELD_SOURCE = 'MYTEXT' where (RDB$FIELD_NAME = 'JXML') and (RDB$RELATION_NAME = 'XMLTABLE') because I get ISC error…
user3179515
  • 393
  • 2
  • 8
8
votes
3 answers

Why temporary table is not allowed in stored procedure in Firebird?

I am trying to create temporary table in stored procedure in Firebird database. My stored procedure listing: SET TERM ^ ; CREATE PROCEDURE initNATIONALHEALTHFUNDS AS BEGIN CREATE GLOBAL TEMPORARY TABLE temp_FUNDS ( NATIONALHEALTHFUNDID…
robsonwk
  • 173
  • 3
  • 11
6
votes
2 answers

Firebird .NET provider and embedded server 3

I'm trying to use .NET Firebird Provider to connect to the embedded FB 3.0.1 server. As far as I know, (also written here (page 6)), there is no more fbclient.dll\fbembed.dll but a single client fbclient.dll used for remote and embedded access. But…
Barzo
  • 999
  • 1
  • 10
  • 30
5
votes
1 answer

How to enable WireCompression on Firebird 3.0 using FireDAC

I am looking to connect to Firebird Server 3.0 using WireCompression. This being new feature since version 3.0 I'm having a hard time to get it to do so and the only documented instructions I can find is setting WireCompression to TRUE in…
Christiaan ten Klooster
  • 141
  • 8
5
votes
1 answer

Firebird 3 sysdba password stunning issue

I migrated from firebird 2.5.x to 3.0 i have changed firebird.conf : WireCrypt = Enabled AuthServer = Legacy_Auth, Srp, Win_Sspi after that here you are what happened: I can connect from Netbeans IDE using SYSDBA masterkey. I can connect from…
kamel2005
  • 419
  • 3
  • 12
4
votes
1 answer

How can I delete all tables from a Firebird 3.0 database using single query?

I'm working on JSF application that uses a Firebird 3.0 database containing hundreds of tables. I need to delete all tables time to time. I have checked this query: DROP TABLE TABLE_NAME but only one table can be deleted at a time by using this…
Nitin Upadhyay
  • 101
  • 12
4
votes
2 answers

How to enable wirecompression on Firebird 3.0

I work with Firebird and Delphi, I want to implement access via internet with wirecompression; But I am unable to activate it. I have followed the steps inside this document for the new parameter(one of the few I was able to find) How to enable…
gasaluy
  • 41
  • 2
4
votes
3 answers

Firebird 3 on macOS, local connection fails with: Can not access lock files directory /tmp/firebird/

I've installed firebird 3.0 from the package provided by firebirdsql.org. If I try to use a local connection to a database: isql employee -user SYSDBA it fails with: Can not access lock files directory /tmp/firebird/ So adding read/write/execute…
jonjonas68
  • 485
  • 3
  • 13
4
votes
2 answers

Fastest Way to Generate Range of Numbers

What is the fastest way to generate numbers between two values. For example: 1st Value: 6,000,000 2nd Value: 7,500,000 I have to create 1,500,000 rows like below 6,000,001 6,000,002 . . 7,500,000
Mohammed Rabee
  • 335
  • 2
  • 6
  • 23
4
votes
3 answers

Flamerobin connection failed with Firebird 3.0 in Ubuntu 16.04 LTS - Error: connection rejected by remote interface

I just installed Firebird 3.0 in Ubuntu 16.04 LTS. I can connect to the server with Flamerobin from a Windows computer. I also installed Flamerobin in the server to be able to manage the databases locally, but after to register the server and…
AngelAvila
  • 418
  • 5
  • 14
3
votes
1 answer

Firebird database UDF for encrypt/decrypt not freeing memory

I'm testing a UDF external function in Firebird 3 database, I made a C++ DLL which performs a simple XOR to a given string using a given key. This is the code: #include #include #include #include #include…
Pablo Sanchez
  • 113
  • 7
3
votes
2 answers

Query optimization with in (select ...) clause

I'm using Firebird WI-V3.0.4.33054 on Windows. I'm having trouble optimizing this query, that uses an in clause with a select: update CADPC p set p.STA = 'L' where p.COD in (select distinct CODPC from CADPCI_Rec where IDNfr = 27) and not exists…
GabrielF
  • 1,913
  • 1
  • 13
  • 29
3
votes
1 answer

Forgot the username and password of *fdb (firebird) database. Is there anyway I can crack this database?

I have database of firebird of more than 8 GB and I want to migrate all the data from it. But I have forgotten the username and password. Is there anyway or any tool through which I can crack this database and can get my data back?
Rana Hadaiq Ahmad
  • 51
  • 1
  • 1
  • 6
1
2 3
…
11 12