Embedded Base on Windows Share?

users
#1

Hi, I want to create a small embedded Base db for 3 or 4 users. It is a mix of Gnu/Linux and Windows desktops. I can create a Base db just fine on my person Debian laptop, but if I try to create it on our Windows share, or copy it there and then use it, I get an error that Base cannot communicate with the database. I can read/write to the share fine with a file manager or text editor... so I am thinking this has something to do with the nuances of NTFS, or file locks, or something like that. Does anyone have any insight on that, and related work arounds?

#2

Hi Christopher:

  I'm not an expertise on this kind of problem but at first, usually, is
necesary that you share this:

1) LibreOffice version on GNU / Linux
2) LibreOffice version on windows
3) Your GNU / Linux S.O.
4) Your windows S.O.

Regards,

Jorge Rodríguez

#3

Hi Christopher,

Hi, I want to create a small embedded Base db for 3 or 4 users. It is a
mix of Gnu/Linux and Windows desktops. I can create a Base db just fine
on my person Debian laptop, but if I try to create it on our Windows
share, or copy it there and then use it, I get an error that Base cannot
communicate with the database. I can read/write to the share fine with a
file manager or text editor... so I am thinking this has something to do
with the nuances of NTFS, or file locks, or something like that. Does
anyone have any insight on that, and related work arounds?

I have seen this reported elsewhere (on other mailing lists). It might
be a bug, or it might well be a share lock option (either in soffice or
on the share itself). What are the options in your CIFS mount ?

Can you read/write to the share with other LibreOffice document types ?

Alex

#4

For multi-user access you need a database server. It is fairly easy to
convert your embedded HSQLDB into a server application.

#5

Hi Christopher,

Hi, I want to create a small embedded Base db for 3 or 4 users. It is a
mix of Gnu/Linux and Windows desktops. I can create a Base db just fine
on my person Debian laptop, but if I try to create it on our Windows
share, or copy it there and then use it, I get an error that Base cannot
communicate with the database. I can read/write to the share fine with a
file manager or text editor... so I am thinking this has something to do
with the nuances of NTFS, or file locks, or something like that. Does
anyone have any insight on that, and related work arounds?

Thanks for letting me know about your setup (I guess you used reply only
to me because I didn't see it appear on the mailing list).

I have just created an embedded hsqldb ODB file (i.e. the default ODB
type) with LO 5132 on OSX 10.11.5, in which I saved the ODB file to a
SMB share hosted on a Linux Mint 17.3 server. I can open, read, and
write to the file from either the LM server or the Mac OSX client.

My guess would be that the issue lies with your Win 2008 server.

Alex

#6

I tested using LibreOffice Base 5.1.3.2 from one of the Windows PCs, and received the same error. So the problem doesn't have anything to do with the mounting on my Debian system, anyway.

Thanks for your testing. It does look to be some problem in either the 2008 SMB protocol, or the underlying file system implementation. I wish the LibreOffice error message was a little more clear about exactly what the communication problem is.