Controls greyed out on forms

English
#14

Did LO crash?

#15

Well it didn’t seem to want to save any new data etc, because it continually asked if I wanted to save it, and finally after many attempts to do so, I then just said No , to save. So , yes LO probably did crash. The thing is though, LO crashed with 2 databses, 1 twice.

#16

Internal databases aren’t very safe for data. If you are using Base together with an external Firebird file (or an external HSQLDB-folder) data will be saved if changed any row. So a crash of LO won’t mean dataloss in the database.

#17

Can be an issue with the rights to write in the folder where the databases are opened?

#18

Could you point me to a tutorial on using external Firebird file or HSQLDB folder, as this is something I could do with. I have another database with over 8500 records, and don’t want to lose them.

Actually this is the first time this has happened to me in the 6 / 7 years I have been using LO, but there i a first time.

Thanks

#19

@avvy651 : It is described a littel bit in English documentation | LibreOffice Documentation - LibreOffice User Guides (Base Guide). It is (nearly complete) a translation of Handbücher | LibreOffice Documentation - LibreOffice User Guides (Base Handbuch). I will update the Base Handbuch to the release of LO 24.2. at the end of this month.

#20

Thanks, and I have installed firebird-server 3.0, following a YT video,
I’ve got as far as this:

rob@rob-Z97-HD3:~$ sudo isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect \Documents\base\LeedWXData.odb
CON> connect \Documents\base\LeedWXData.odb
CON> connect \Documents\base\LeedsWXData.odb
CON> user ‘SYSDBA’ password ‘masterkey’ ;
Command error: connect \Documents\base\LeedWXData.odb
connect \Documents\base\LeedWXData.odb
connect \Documents\base\LeedsWXData.odb
user ‘SYSDBA’ password ‘masterkey’
SQL>

So at this point , is my existing database connected to firebird, and what exactly happens after I add more data or records.

Thanks

#21

@avvy651 : You won’t need a server.

  1. Set experimental features on.
  2. Create an internal Firebird database.
  3. Set experimental features off.
  4. Open internal Firebird database.
  5. Have a look for firebird.fdb file in you temporary folder. It should be in a subfolder together with firebird.fbk.
  6. Copy firebird.fdb file to a location where you want to save your data.
  7. Close the internal Firebird database connection.
  8. Create a new connection to an existing database. Choose Firebird file here.
  9. Connect to the file and you have an external Firebird database without server.

You will need a server if you want to connect to the database file with more than one user at the same time. Standalone user could also work with the Firebird file. But: Firebird file isn’t password protected. This could be done by a server connection.

#22

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

#23

@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.

#24

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

#25

This link may help: Firebird Connection

#26

LibreOffice has an internal driver for this. Choose

grafik
grafik618×596 42.1 KB

You won’t need ODBC or JDBC for connecting to Firebird file, if Firebird file is extracted from an internal database (Firebird version 3)

#27

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.

#28

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)

#29

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

#30

@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.

#31

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

#32

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.

#33

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

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.