Questions tagged [firebird-embedded]

Variant of the Firebird database client library that also includes the database server, packed into a single dll or so file. Use this tags for questions about Firebird embedded. It is advisable to also tag with Firebird

Special variant of the Firebird client library that also includes the server. Each Firebird server release also has a release package for Firebird embedded, see the downloads page of a Firebird release.

The major difference between the Server and Embedded versions is the lack of authentication/protection on the database.

The features of embedded are useful for developers wanting to create easy to distribute single-user applications that do not need security.

See also

93 questions
1
vote
0 answers

Firebird Entity Framework

I am using Firebird database and newly started with this database so I am implementing with Visual studio 2015. I am accessing a Firebird Embedded database using ADO.NET and my Firebird Embedded database file extension is .CMP. I am successfully…
1
vote
1 answer

Appcrash in fbintl.dll if using embedded mode in my C#-App

I'm using the embedded version of Firebird SQL 2.5.8 with my C# application (.NET 4.6.2, FirebirdSql.Data.FirebirdClient 5.8.0) On a Windows 8.1 client the following error occurs if I quit the application: Problemsignatur: Problemereignisname: …
anli
  • 515
  • 6
  • 9
1
vote
1 answer

Connecting to Firebird database from Windows local network

I have been writing a small Python app for several weeks. The application reads data from a Firebird database and it copies it to another DB. I'm using FDB with Firebird embedded.This is my connection code. def createConnectionTo(path): try: …
user8794709
1
vote
2 answers

Firebird embedded installation issue: library could not be determined

I've been writing a small Python application that opens a Firebird database.To achieve this goal I'm using Firebird embedded 2.5.7.27050, 64 bit.Although, whenever I try to connect to the DB file with Python, I get the following error: Traceback…
user8794709
1
vote
1 answer

How to setup Embedded Firebird and access from Java Application?

I have a Firebird DB file, test.fdb in some directory, I want to access the DB from java application. What are the required libraries files to access. I am using Jaybird JDBC Driver to access the embedded Firebird database, but I'm getting the…
koiralo
  • 22,594
  • 6
  • 51
  • 72
1
vote
1 answer

How can get the error code from an Firebird Database

We are using an embedded Firebird V3.0.2 for our MVC5 Project Problem: When we update the software, we want to find out if a table exists before we create the new table. Therefor we simply make a select on the desired table and if an exception with…
Simon
  • 4,157
  • 2
  • 46
  • 87
1
vote
1 answer

How does one use FbTransactionOptions / TransactionBehavior to implement a wait?

How does one use FbTransactionOptions / TransactionBehavior to implement a Wait? I have found some info about using FbTransactionOptions / TransactionBehavior, but not enough details to implement. string stCmd = "UPDATE " + stTableName + " SET " +…
ttom
  • 985
  • 3
  • 12
  • 21
1
vote
1 answer

What data type should I use for variable length with German characters?

What data type should I use for variable length with German characters? I'm not sure the following is ok. public const string stFIELD_DEFINITIONS = " fstInfo VARCHAR(100) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY KEY "; "VARCHAR(x)…
ttom
  • 985
  • 3
  • 12
  • 21
1
vote
0 answers

Programatically detecting being in a sandbox and / or being subject of folder virtualization

I rewrote the question from scratch in order to focus on what really is asked and avoid helpdesk-like comments or answers I have recently faced an issue (two instances of it actually), where one of my windows programs, which is using Firebird…
Kitet
  • 855
  • 1
  • 10
  • 20
1
vote
1 answer

Java doesn't release all resources on app close

I have two javafx apps an App and Updater. App uses Firebird database to store some fragile user data. Database runs in embedded mode (I think it's relevant), so that means that there can be only one connection to the database at the same time…
straw
  • 33
  • 6
1
vote
1 answer

Hibernate, GDS Exception. 335544569. Dynamic SQL Error with Embedded Firebird

I get this exception when I configure Hibernate for embedded firebird. this seems to be a dialect issue (not sure though). Here is the situation I am in: I am trying to build an web application using Spring, Hibernate, Firebird (embedded). I …
Maruthi
  • 33
  • 1
  • 6
1
vote
1 answer

Embedded Firebird and Log4j configuration

I am trying to configure and use embedded Firebird with log4j. Essentially I want to log my entries to a DB table (Firebird). I am unable to do so with "Connection Refused" error complete call stack pasted below. There was one possibility for this…
Maruthi
  • 33
  • 1
  • 6
1
vote
2 answers

Embedded firebird not accepting create table statement

The following SQL code works very well on MYSQL, and it contains valid SQL query language. However this doesn't work on embedded Firebird server. The SQL code: CREATE TABLE publications ( id int(11) NOT NULL, filename varchar(500) NOT NULL, …
Damilola Olowookere
  • 2,253
  • 2
  • 23
  • 33
1
vote
1 answer

How to release database file? (NHibernate and embedded Firebird database)

We are using Nhibernate to connect to a local firebird database file. We currently load it embedded but in some occasions need to release it so the file on disk can be moved or deleted. Simply closing and disposing the sessionfactory in nhibernate…
Robert
  • 2,357
  • 4
  • 25
  • 46
1
vote
3 answers

Firebird - field ID must have a value

My Firebird field (ID) functions like an autoinc field (it has a generator and a trigger for the occasion). When I use Firebird Maestro and do some manual inserts the autoinc field functions ok (I just need to refresh the table). However, on Delphi…
user3927897
  • 611
  • 3
  • 10
  • 20