sharing and accessing a database over the lan or ftp network

asked 2021-03-05 05:40:28 +0200

goedible gravatar image

I've created a split database and I'm trying to share it over my lan network and the world wide web with ftp. My lynksys smart wifi has a usb drive that I put the database on. I'm able to reach it using smb://192.168.1.1 however when I try to access tables I get:

The connection to the data source "LANdpLAN" could not be established. The driver class 'org.hsqldb.jdbcDriver' could not be loaded.The additional driver class path is 'smb://192.168.1.1/workshare/LANdpLAN/hsqldb.jar'. /build/libreoffice-8BBQp1/libreoffice-7.0.4~rc2/connectivity/source/drivers/jdbc/JConnection.cxx:687 unknown protocol: smb /build/libreoffice-8BBQp1/libreoffice-7.0.4~rc2/connectivity/source/drivers/jdbc/Object.cxx:189

When I download the database to the hard drive I can access the tables no problem. Is there a way to access this database without needing to download it to the hard drive?FYI

FYI here is the database https://drive.google.com/drive/folder...

edit retag flag offensive close merge delete

Comments

unknown protocol: smb

Share on the operating system level using operating system functionality (mount -t cifs ....) and access your network device via mounted share. Doing so makes the storage to appear as a normal path to applications and abstracts the protocol level from the application and delegates it to the operating system.

Opaque gravatar imageOpaque ( 2021-03-05 10:59:32 +0200 )edit

Opaque: Thank you for the advice. I am looking for instructions how to do this.

I found this video and had success with sudo apt-get install cifs-utils -y and sudo mkdir /mnt/workshare. In the video the folder shows up in 'Documents' folder. On my system it only shows up in /mnt still looking around...

I am shooting in the dark so I tried mount -t cifs 192.168.1.1 and got mount: 192.168.1.1: can't find in /etc/fstab.

Next I tried j@j:~$ sudo mount -t cifs -o username=workshare //192.168.1.1/workshare /mnt/myFolder/ Password for workshare@//192.168.1.1/workshare: ** mount error(112): Host is down Refer to the mount.cifs(8) manual page (e.g. man mount.cifs)

goedible gravatar imagegoedible ( 2021-03-16 02:58:09 +0200 )edit