Power Up Your Database with Firebird Server & LibreOffice Base

2,854
0
Published 2023-06-14
How to Download, Install and Configure Firebird Server database for LibreOffice base and then configure an ODBC link so your LibreOffice base firebird server database will also work with Microsoft Access, LibreOffice Calc, Excel, Python and many other programs.
☕ Ko-FI Support ... ko-fi.com/seanbjohnson ☕ or buymeacoffee www.buymeacoffee.com/seanjohnson
I show you how to create some tables and using various methods and also create an autonumber field to make your database development easier.
This is the first of a series of videos covering LibreOffice base and Firebird server.
BlogPost Link for this tutorial www.businessprogrammer.com/install-firebird-server…

Video Production
===============
📷 Sony Camera: amzn.to/3mqyqfu
Elgato HDMI Stream Capture: amzn.to/2Yfyrum

Microphones
-----------
🎤 Screen Casting: amzn.to/3a2TnHN
🎤 Microphone and Arm: amzn.to/3iwvL2S
🎤 Talking To Camera: amzn.to/3FqXI6b

Video Kit
-------------
Lights
Elgato video Lights: amzn.to/3sSK3xg
Background Light: amzn.to/3uTXyPh

Note Taking
-----------
Rocketbook reusable notebook amzn.to/3sSK3xg


#LibreOffice #Database #LibreOfficeBase #Firebird

DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links and purchase within 24 hours, I may receive a small commiss

All Comments (7)
  • @GreenJack451
    How do you make the writing with pen to see it. Fascinating.
  • @rccar354
    Thanks for showing some of the programing that happens with Flamerobin, Firebird, ODBC and LibreOffice BASE. As A newbie I don't really understand what your task manager does. Respectfully, I am not sure that I do. My main interest for watching was to try and learn more about using Flamerobin. I want to try and use Delphi 11 and Firebird 3 more. But first I have to decide on what goes into my Database. I have two Firebird v3 Databases. A single table database and one database with five tables. 1) How do I check their integrity and /or repair them ? can that be done in Flamerobin ? 2) one database has a table "x" (81 000 entries) and four other tables "a", "b", "c", "d" and another second database has a same database "x" (82 700 entries) [ let's call it "x"(Max) ]. If I want to keep the table "x" (Max) with the largest number of entries and move/copy the other four tables "a", "b", "c", "d" into that database containing table "x" (Max), is there an easy way to do that using Flamerobin ? To reiterate, this question is on how to copy four tables into another database. 3) So, assuming I now have all the tables I want in one Database, is there a way to obtain a 64bit ODBC driver for Paradox 7 tables ? I have only been able to find 32bit versions. This is for datapumping into Firebird 3. If one of the programs is in mis-match ie not all 32-bit or not all 64 bit then datapumping is doomed to fail. Anyway, thanks again for the Flamerobin tutorial it is much appreciated. Out of curiosity why did you leave the language field blank when creating the Flamerobin connection ? Cheers
  • @edwardbaker8200
    The video tutorial is excellent but my progress has been slowed by getting Firebird, Flamerobin and LibreOffice installed and configured using Linux with a Manjaro distribution. Firebird and Flamerobin are cooperating with one another (finally!) but it seems that LibreOffice 7.6 works on partially with Firebird-5. I can not enter or edit records through LibreOffice base to a Firebird database. From my short investigation it looks like I might have to retard Firebird all the way back to version 2.5. Have you had any similar experiences? /r Ted Baker, Newry, Maine, USA
  • @encapsulatio
    Would you be willing please to show how to automate data entry in LibreOffice Calc using Python? A good example for me and what I need is showing how to OCR a PDF, extract data, sort and categorize data and fill Libreoffice Calc table with data, all using Python.
  • @user-eh3tt6jy7l
    I was able to resolve the Firebird issue and also downloaded Flamerobin and the OCDB. I was able to run the test connection successfully. However, when I opened the Flamerobin to connect to the Taskmanager FBD file it gave me an SQL message of 902. It indicated it could not find the file. So if you have a solution Im open to suggestions. I know you are a busy person so if you don't have time I understand. Thanks
  • @user-eh3tt6jy7l
    Tried to download Firebird. It shows up as unconfirmed and I don't know where to go from there. Thanks