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 a previous release of the Firebird database server. The latest release is .

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

211 questions
18
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
  • 955
  • 2
  • 11
  • 31
11
votes
2 answers

How change a column type in Firebird 3

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 335545030…
user3179515
  • 513
  • 1
  • 4
  • 9
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,…
DaddyRatel
  • 729
  • 3
  • 13
  • 30
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
  • 4
  • 11
7
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
  • 1,039
  • 1
  • 11
  • 37
5
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
  • 71
  • 1
  • 1
  • 6
5
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,463
  • 6
  • 41
  • 76
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
  • 459
  • 3
  • 13
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
  • 113
  • 1
  • 15
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
  • 495
  • 4
  • 13
4
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? …
Евгений
  • 41
  • 1
  • 5
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
  • 345
  • 2
  • 8
  • 23
4
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,366
  • 3
  • 24
  • 43
1
2 3
…
14 15