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

Cannot drop Firebird table when using multiple connections

I would like to safely drop Firebird table. I have 3 transactions, one to recreate table, one to do something with the table (just inserting a single row to keep it simple) and the last one to drop the table. If all these txns are executed using…
Jaromir Flidr
  • 35
  • 4
0
votes
2 answers

How can I join 4 table?

I have 4 tables, three are many to many relationship: Student(StudID,GroupId,Name,....) Lesson(LessID,LessonName,Mark) StudentLesson(StudID,LessID) and the relationship between student and Group is One to…
Sahat
  • 29
  • 1
  • 7
0
votes
0 answers

How to set the set_stream_blob_threshold in FIrebird fdb python library?

Trying to migrate data from Firebird DB to MS Sql Server using fdb(2.0.1) and pyodbc. Since there are blobs in the Firebird database which are over 64K, they are being returned as BlobReader objects. Since i would like not to deal with the bytes…
Dan
  • 2,209
  • 3
  • 23
  • 44
0
votes
1 answer

How can I change/create the sysdba password for firebird 3.0 embedded

How can I change or set the SYSBDA password for a firebird 3.0 embedded database. I don't/can't want use the local or default authentication.
kaiserilich
  • 3
  • 2
0
votes
1 answer

How can I create a user in embedded Firebird 3.0

I need to create users in Firebird 3.0 embedded databases, but using with standard command returns error. command: CREATE USER miusuario PASSWORD 'miclave'; return: Engine Error (code = 335544382): Missing user management plugin. SQL Error (code =…
kaiserilich
  • 3
  • 2
0
votes
1 answer

'No Entity Framework provider found for the ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient'

By initializing the MYDbMigrator get the exception about provider not found. Is migration supported by firebird any other way to register the provider. Also tried to configure with appconfig but configuration section system.data cannot be…
DronBoard
  • 73
  • 2
  • 11
0
votes
1 answer

procedure return True or False

I need a stored procedure in firebird 3.0 to return True, False or 1,0 result to check if this person or the record exists in database. If exists the procedure should return true, if not return False, or return 1, if not return 0 This is my…
Sahat
  • 29
  • 1
  • 7
0
votes
2 answers

Where is the Firebird DB log file located in Windows?

I just installed Firebird 3.0.6. When running this command in isql from the documentation: SQL> connect localhost:employee user sysdba password somepassword; Statement failed, SQLSTATE = 08006 Error occurred during login, please check server…
Dan
  • 2,209
  • 3
  • 23
  • 44
0
votes
1 answer

How can I read the first n rows of table a based upon the number of rows in table b?

I have a table "L20" that contains 1 to 20 values "HDIF" in it, sorted in ascending order. I need to extract the first 1 to 10 of those values into table "T10" depending upon the number of values in table "L20". I'm using Windows 10, Libreoffice…
Bruce Reirden
  • 13
  • 2
0
votes
1 answer

Implementing unique connections for each goroutine using firebirdsql

I'm intending to populate multiple firebird databases from multiple goroutines concurrently and in order to do that my worker function has a map (dbConnections) that holds the connections to databases (maps the name of the database to the…
wiki
  • 1,877
  • 2
  • 31
  • 47
0
votes
1 answer

Merging multiple related firebird select procedure using If else or case method

How to merge this two firebird select procedure using this REFERENCE variable thru if else, case, or other method. If REFERENCE = 1 then the procedure 1 will display, if REFERENCE = 2 then the procedure 2 will display. I am trying to have 1 select…
Don Juan
  • 155
  • 1
  • 10
0
votes
0 answers

Firebird3.0 security3.fdb get corrupted/edited everyday resulting "isc_attach_database failed"

We are using software that works on top of Firebird. It was all fine until work-from-home started. There where issues with firebird 2.5.x and connections that after some time people could not connect anymore. The software manufacture hint us that we…
Michal Sapsa
  • 52
  • 1
  • 6
0
votes
1 answer

Safe to clean out C:\ProgramData\firebird folder when FB offline?

Is it safe to clean out the contents of the C:\ProgramData\firebird folder, i.e. wipe it, when the Firebird service (superserver, v3.0) is not running? I understand that it contains lock tables etc. so should not be touched while FB is running. But…
Kjell Rilbe
  • 1,331
  • 14
  • 39
0
votes
1 answer

Fast SQL returning AVG for multiple column-condition pairs

Let's suppose there's a table like this: --------------------------------------------------------------------- | id | val_1 | val_2 | ... | val_n | attr_1 | attr_2 | ... | attr_n…
Old Skull
  • 165
  • 7
0
votes
2 answers

After downgrading database FB3 to FB2.5 - no permission for read/select access to DATABASE

I'm getting error "no permission for read/select access to DATABASE" when I try to connect to a Firebird database with a user different than SYSDBA, lets say user SOM. If I create a new database with SYSDBA on the same server, then grant access to…
nmm
  • 108
  • 7
1 2 3
…
14 15