Stack Overflow
Stack Overflow

Questions tagged [firebird]

Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

3750 questions
1
vote
1 answer

dbxfb not found when using firebird 2.5

On my development machine, I have Delphi 10.2 and Firebird 2.5. Database apps that I create in this configuration work correctly. I copied one program along with its database to another computer running Windows 10. I installed Firebird; I also…
No'am Newman
  • 6,395
  • 5
  • 38
  • 50
1
vote
1 answer

Is it possible to define table type input parameter of stored procedure in Firebird?

I need to define stored procedure with table type input parameter, so for example, if I am calling stored procedure from C# and pass datatable as argument to stored procedure, automatically will be mapped to the columns and fields? I read about…
projo9494
  • 67
  • 6
1
vote
1 answer

PDO with firebird throws "�" ​when there is a "ñ" letter

My table: +--------+----------+ | U_COD | U_NAME | +--------+----------+ | 01 | Daniel | +--------+----------+ | 02 | Ñandu | +--------+----------+ | 03 | Pañ | +--------+----------+ I am connecting and doing a simple query…
Roberto Sepúlveda
  • 415
  • 4
  • 14
1
vote
3 answers

Problem injecting a VB parameter into a stored procedure (FireBird)

Everyone here has always been such great help, either directly or indirectly. And it is with grand hope that this, yet again, rings true. For clarification sakes, the Stored Procedure is running under FireBird and the VB is of the .NET variety I…
Jasoomian
  • 179
  • 2
  • 13
1
vote
4 answers

How to access a interbase/firebird db via network with two or more computers

I made a program that accesses a firebird DB in network environment. I access the DB via Network in two different points of the network normally. But if I open the two programs simultaneously this exception is thrown on the second program, which…
okami
  • 11
  • 1
  • 2
1
vote
1 answer

Extract detailed statistics per table from an SQL statement in Firebird

I would like to be able to extract read-by-table statistics from the SQL statements executed by the system to generate a log of "suspicious" statements. In IBExpert, there is a feature that allows you to view, when executing an SQL statement, the…
Vinicius Biazzi
  • 13
  • 2
1
vote
1 answer

Agent start a call when the previous is still in progress

I have a CALLS table with CALL_ID | OPERATOR_ID | CALL_START | CALL_END | NOTES | TYPE ========+=============+=======================+=======================+=======+====== 101 | 3000 | '2020-12-12 08:00:00' |…
L_GIB
  • 125
  • 7
1
vote
0 answers

How to solve Firebird searched case error inside a PSQL function

I need to write a very simple Firebird function create or alter function some_function (A NUMERIC, B NUMERIC) returns double precision as begin return case when (B <= 2.5) then A - 2 when (B <= 5.0) then A - 1 else…
alvaroc
  • 433
  • 5
  • 14
1
vote
2 answers

Is Firebird's blob size is only 32kb?

I have Firebird database with blob field for pictures in base64 format. If I try to upload encoded picture with more than 32kb size it gives me exception: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error SQL error…
ezh
  • 23
  • 4
1
vote
1 answer

Firebird insert into according to a condition

How can I insert a data from one table to another table according to a column condition For example one table there is a column.if its value is 1 then insert Database:Firebird 2.5
Birikim Bilgisayar
  • 19
  • 1
1
vote
2 answers

Firebird default user not set

When I try anything in isql, I get the message: Your user name and password are not defined. Ask your database administrator to set up a Firebird login. unable to open database When I try to create the user I still get the message: C:\Program…
Guido Kleijer
  • 559
  • 1
  • 5
  • 7
1
vote
1 answer

Unable to connect to data source: library 'gds32.dll' failed to load - Firebird Connection PHP odbc_connect

I am trying to connect to a Firebird database using PHP. This is the simple code that I use to connect to it. $user = "******"; $password = "******"; $ODBCConnection = odbc_connect("DRIVER={Firebird/InterBase(r)…
Sebastian
  • 87
  • 2
  • 11
1
vote
1 answer

Extract data from a firebird database with python fdb module

I'm trying to read the data from a Firebird database, created by Firebird version 2.5, by using the FDB module from Python. Unsuccessfully. I have a Python v3.7.3 on a Windows10 64 bits system. I am able to connect to the database and read the names…
GgF
  • 15
  • 4
1
vote
1 answer

Add list of IDs as parameter for Firebird query in C#

I would like to update a list of rows given by a list of IDs. Normally, the parameters of the query can be passed via the parameter property. But if I pass a list of IDs, Firebird will not accept the query. I'm using the…
Jan B.
  • 104
  • 8
1
vote
1 answer

TIBDatabase change client library

I have an application that uses Firebird as its database. Now I would like to use the embedded version (of Firebird) for a temporary storage. Is it possible use a alternative client library only for a particular IBDatabase component? I didn't find a…
Marco Andreolli
  • 316
  • 5
  • 19
1 2 3
…
99 100