Cannot open LO Base file over network

[CMWhitley]

Running the following:
Linux Mint 19.3 w/Cinnamon 4.4.8
Libre Office 7.0.6.2
OpenMediaVault on RaspberryPi 4. version 5.6.20-1

I can easily open, read, write all files, file types, from my OMV NAS except LibreOffice Base.

I need just 2 laptops to be able to open/read/write to a LOBase file {not at the same time} but always get an error when attempting to open the file over my LAN to my OpenMediaVault NAS.
ERROR MSG Displayed:
The connection to the data source “LO_BaseForm_Calc_Data” could not be established.

The given URL contains no valid local file system path. Please check the location of your database file ./build/libreoffice-bQ03aw/libreoffice-7.0.6/connectivity/source/commontools/dbexception.cxx:399

Well I cannot locate that directory structure, and to be honest, even if I could find it, I doubt I could make sense of it.

I tried to create/save a New Base file to my NAS but it would not save so it seems LO Base does not like something on my NAS.

[RobertG]

Seems you have created a Base file to connect to a Calc file. So Calc file must also be available for the Base file in LAN. But: You couldn’t write data into a Calc table through Base …

To which database do you want to connect? Calc, internal HSQLDB or Firebird?

[CMWhitley]

Thanks Robert for taking the time to look at this. I have a couple of Calc and HSQLDB files which I would like to have LAN access to by 2 laptops. In reality, as LO is so flexible and feature rich I probably could use just Calc but would prefer to use an actual dB. I am totally ignorant of Firebird as a dB but I will investigate this.

I found a similar problem with SQLite but found this path to work "$con.Host = "/run/user/1000/gvfs/smb-share:server=raspberrypi-2.local,share={all my directory stuff xxxxxxxxxxxx/xxxx/etc}

I found by using the path above, I could at least successfully “Register” a database but alas it would not open. Seems I got part way but not all that was needed.

Thanks again, it is greatly appreciated

[RobertG]

Have tried it with the NAS of my FritzBox (Router). When trying to open a database file with internal HSQLDB I won’t get access to the tables. But opening a database file with internal Firebird will work.

But: It isn’t possible to create new tables, queries, forms and reports. Could be a special problem with Java …
No problem to open existing tables, input data, open forms and work with it.

[Wanderer]

I can only add similiar experience when using Base .odb connecting via odbc to a sqlite-file in the same folder, wich was mounted to a Windows Drive-Letter like d:
.
As this didn’t work i just sync the folder to local storage, as it is used read-only and changed only from one person/place.