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
2
votes
2 answers

Update Statement using values from multiple tables

I am trying to update values in my Firebird-SQL database where I need to use values from other tables in the WHERE clause. The statement looks like this: UPDATE table1 SET date = 'TODAY' FROM table2 WHERE table2.id = table1.table2_id AND…
2
votes
1 answer

Making Firebird work with Entity Framework Code First and Migrations

I am getting this error, when typing enable-migrations in packagemanager. No Entity Framework provider found for the ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient'. Make sure the provider is registered in the…
BjarkeCK
  • 5,694
  • 5
  • 41
  • 59
2
votes
1 answer

Getting Mono and Firebird Embedded working on Linux

I was recently looking into Firebird Embedded as a product that could replace SQLite in my project. The thing is, I would like to be able to use the same compilation of my application both on Windows and Linux, and unfortunately with SQLite it's not…
moskalak
  • 271
  • 2
  • 12
2
votes
3 answers

Connecting to Firebird embedded on D2010

I downloaded the Firebird DBX driver from http://sites.google.com/site/dbxfirebird/ and I've been able to compile the "Test Connection" project and get it to run. I pointed it to my test DB like so: procedure TMainForm.Button1Click(Sender:…
Mason Wheeler
  • 82,511
  • 50
  • 270
  • 477
2
votes
1 answer

BLOB Compressed but Firebird embedded db file size not changed

we have used Firebird embedded for saving 10 records(each with 400KB BLOB field) into a database file, and the database file size is about 5MB. We try Compressed BLOB about 30-40%(compressed BLOB size is less than 300KB), but the database file size…
2
votes
1 answer

Java and Firebird Embedded how to set up?

I would like to develop a Java application which use FireBird Embedded to store some data. I am trying to make it this way: http://www.firebirdfaq.org/faq350/ I don't know how I can set the "FIREBIRD environment variable" or how can I set parameters…
szedjani
  • 550
  • 2
  • 6
  • 21
1
vote
1 answer

The type of the SQL statement could not be determinated

When I'm trying to execute following query CREATE TABLE STUDENT ( ID INTEGER NOT NULL PRIMARY KEY, NAME VARCHAR(255) NOT NULL ); CREATE GENERATOR GEN_STUDENT_ID; SET TERM ^ ; CREATE OR ALTER…
Andrey Ashgaliyev
  • 157
  • 1
  • 4
  • 15
1
vote
0 answers

Firebird 4 embedded in external folder

I created a "Firebird4x32" folder in which I have all the necessary files to access the Firebird database in embedded mode. If I copy the content to the root directory of the application (e.g. D:\app), the database is loaded and the application…
Jirka
  • 11
  • 2
1
vote
1 answer

How to connect FireDAC to Firebird 4 database without using a server (embedded mode)?

I would like to be able to connect my Delphi/FireDAC application directly to a Firebird 4 database file without installing the service. I expected to be able to do this by using the local protocol, and just specifying the file. However, I get the…
Jared Davison
  • 333
  • 3
  • 11
1
vote
1 answer

Firebird database in Embedded in C# with Entity Framework

Can Firebird database be used in embedded mode like SQLite? When working with Entity Framework in SQLite, if I write the database name in the connectionString (example.db), when I run it, a new database is opened in the bin folder. Can I use…
1
vote
2 answers

Firebird embedded server not loading in ASP.NET MVC 3 project (Unable to load DLL 'fbembed')

In an ASP.NET MVC project (using Entity Framework 4.1 code first approach) i added a reference to C:\Program Files\FirebirdClient\FirebirdSql.Data.FirebirdClient.dll. The configuration in Web.config looks as follows:
Savvas Sopiadis
  • 8,213
  • 10
  • 34
  • 53
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
vote
1 answer

Does Firebird 3 embedded server have major disadvantages?

Are there major disadvantages using the embedded Firebird 3 in a multi-user application server (Delphi Webbroker) instead of the full blown server install? The application usually has very short transactions with low data volume. As far as I am…
MichaSchumann
  • 1,361
  • 1
  • 17
  • 36
1
vote
1 answer

Problem connecting to Firebird 3 embedded with C# in .NET

I am trying to connect to Firebird 3 embedded database from a .NET project. I have copied all the files of Firebird to the executing directory of the application. I have used the following connection string builder: var builder = new…
AminTN
  • 90
  • 1
  • 6
1
vote
0 answers

Character Set ISO8859_1 is not Installed

I have created a C# windows application which is updating a database from Firebird Server to SQL Server. It was successfully running in Visual studio 2015, but when I published(deployed) it and installed in system or others system and when I run the…
Amarnath
  • 113
  • 2
  • 11