How to allow Firebird as option for embedded database in LibreOffice filename: LO0FirebirdOn.htm LibreOffice / OpenOffice ooBase (database) Tutorials.

Connect to Firebird from C# using a connection such as ODBC.'FDB' directory: 'Free Data Base', 'LO': 'LibreOffice'.

To verify the embedded engine version, in LO Base go to Tools -> SQL and run the query from Ways to Determine the Version of Firebird SQL? This produces 3.0.0 in LO 7.1, the same version as LO 5.3.

Install the correct version of Firebird.Here's another, completely untested idea. If you are willing to work in other languages, Java is much better than C# for working with the LO SDK. There is quite a bit of similar information out there, although it is not well organized so expect to spend some time searching. Working with Base in Java: Create a libreoffice text-based datasource and set settings with java.Once you are able to get C# and LO to work together, look for Base examples online and adapt them into C#, such as: There is a C# example for Calc included in the SDK distribution. (they also use a new db for every project, so a few MB's tops every time the xml conversion is needed)ĭoes anyone know if this is even possible? And how do I achieve this?Īre you trying to connect to the database to run queries with C#? This can be done with the LibreOffice SDK. There is not a lot of data in the file, it should be easy to load into memory so I don't expect any problems there. I'm actually not sure where the data is apart from the fbk file, but googling only tells me that's apparently a back-up file used for restoring, I'm guessing it's holding the actual data, but then? It's only some xml's which define some queries, tables and forms. I have googled for I don't know how long, but I can't seem to find how to do this in. However, I'm having trouble accesing the data from the database file. I've already generated code from the xsds (50K lines of code.) and should be able to map the data in C#, poop out an xml and they are good to go. I'm looking into a issue for a friend where I need to convert some data from a homebrew database made in LibreOffice Base backed by some Firebird implementation (I'm a 100% new to this so I'm not sure how this is called/works) I need to convert this data to a xml which has to confirm to some xsd supplied by some third party company. So, I'm in way over my head here and been trying this for 8 hours and have gotten zilch

Libreoffice base firebird