Ok, I have now removed firebird-server, and installed firebird 5.0.0-0-linux-x64.
As I am running LM 21.2, I don’t have any temporary folder.
How or where do I create an internal Firebird database now, as there only 3 files in the Firebird folder: buildroot.tar.gz, install.sh, and manifest.txt
Thanks
@avvy651 : You didn’t need to install anything except LibreOffice. Internal driver of LibreOffice could also connect to a Firebird file. The whole description I wrote is a description for LibreOffice - nothing else. Firebird version installed with LibreOffice is Firebird 3.0, not Firebird 5.0 you installed. LibreOffice couldn’t connect to files, which were created with Firebird 5.0.
Following your steps, after step 3 there is no Firebird database, because 'The connection to the data source “Firebird test” could not be established
The connection to the external data source could not be established. No SDBC driver was found for the URL ‘sdbc:embedded:firebird’. ./connectivity/source/commontools/dbexception.cxx:413
Error details information:
A connection for the following URL was requested “sdbc:embedded:firebird”.
What else do I need to do now.
It looks like I have to install libreoffice-sdbc-firebird, but that also installs firebird3.0-server-core.
Thanks
LibreOffice has an internal driver for this. Choose
Thanks, and this time I selected HSQLB Embedded as per the picture. The new database was created, and when I open it, get a message saying that 'The document contains embedded HSQL data , which is deprecated ’ Would you like to migrate to Firebird now, which I do, I then get another message saying ’ the connection to the data source could not be established, because it needs sdbc, as my earlier post.
The message you get is the message, that will appear for migrating data from an internal HSQLDB to an internal Firebird database. It shouldn’t appear, because I have written as 3.: Set experimental features off.
Did you create the internal Firebird database? Does it work. Or doesn’t your special version of your distribution support Firebird? I couldn’t create Firebird databases with the version of LO, which is part of my OpenSUSE-installation here. But I could create it with the original packages of LO.
Have a look at this file. It’s you database as an internal Firebird database:
EONUtilities.odb (101.6 KB)
No I didn’t create the internal Firebird database because I don’t know how to.
To be honest,I have no idea if my special distribution?? supports Firebird.
For clarity, I am using LO 7.3.7.2 on a Linux Mint 21.2 OS.
When i tried to open a form of the EONUtilities.odb from you above post, I got an error message saying 'The data content could not be loaded. ./connectivity/source/commontools/dbtools.cxx:747
And:
Error code: 1
firebird_sdbc error:
*Incorrect values within SQLDA structure
*empty pointer to data
*at SQLVAR index 6
caused by
‘isc_dsql_fetch’
./connectivity/source/drivers/firebird/Util.cxx:68
I am beginning to think that in view of these problems I am having, itmight be for the better if I could just go back to how things were before, ie 2 day ago.
I have just found that in another database with 8500 records 2000 records are now missing?? and when I load the said form only 3 records are there!!
I have now un installed Firebird-server, so there is no sdbc driver, but one of my databases has not reverted back to what it was before, When Itry to open a form in the said database which did have 8500 records, it says’The connection to the data source “LeedsWXData” could not be established.
Thanks
@avvy651 : You could open the database and open all tables? Then your LibreOffice installation supports Firebird.
There are some errors in the forms, because
there are unknown functions, which had to be changed from HSQLDB to Firebird
there are fields with the same name in a query or SQL-code. Must be changed by setting aliases.
In my original LeedsWXData database, I cannot open any tables or even access them due to the said error message.
In the LeedsWXData2 database, which is supposed to be connected to LeedsWXData database, I can open the tables but record are missing. Also the controls on the form are greyed out or disabled
I have a backup of the above LeedsWXData base file but does not allow me to access any tables,
The other 2 databases I have , which I did not link or connect in any way to Firebird, work just fine.
I don’t know what you mean or know how to do by your lat 2 comments.
Thanks
You wanted to create a new connection to external Firebird - or did I understand it totally wrong?
To prevent if your system isn’t working with LibreOffice and internal Firebird driver I have migrated your database file to Firebird.
Could you open this file and could you open the tables? If it is so, Firebird will work with your system.
But if you have a working database with content from some days ago it seems to be better for you to switch back to this version, which seems to be a version for HSQLDB.
Yes I wanted to make a connection of an existing database: LeedsWXData.odb, to external firebird, which came up in the drop down box. The connection was made and it gave? me LeedsWXData2.odb.
In this database, when I open the form there are only 3 records, which is also the same number in the query, ie 3 records. But in the table there are 8116 records.Needless to say nearly 400 are missing.
First, which is the file that you have migrated to Firebird. Is it the file which you posted earlier today, if so then yes I can open all the files without any problem.
Secondly, how do I switch back to HSQLB.
Would doing this return my LeedsWXData database to what it was 2 days ago
I just want a working database with all the records, if that is possible now.
Thanks
If you see only 3 record in the query: Might be a filter is set in the query.
You could send me the database per private mail. So we could move back to HSQLDB or solve the problem with the missing rows. I have wrote a description for moving back - but it is all in German.
Ok thank you for the offer,.
the only filter I have is this in the sql:
WHERE “ReadDate” BETWEEN {d ‘2023-01-01’ } AND {d ‘2023-01-31’ }
In the LeedsWXData2 database
Currently there should be 28 days of records upto yesterday, but there are only 3 showing, so that must mean that 25 records have just disappeared
I don’t know what or how many records there are in the LeedsWXData base file as I cannot access any files etc.
I would like to send you this database file,and you could send me an email to robghes@virginmedia.com, and I will reply
I don’t mind either way if you move it back to HSQLDB or migrate to Firebird, which you think is best.
thanks
@Gbp
Thanks but I tried that but it doesn’t work for me.
I don’t get the ‘Save’ button nor ‘Save As’
Email sent, thanks
It was returned back to me as the message failed to be delivered to noreply@ask.libreoffice .org.
Also the address on your website does not work either.
Could you send me the correct address please
Thanks
