Databases on network drives not accessible anymore

[Sierron]

Details

Databases on a network drive can no longer be opened by the database dialog (add, edit). The reason is that they are not available in the open folder dialog.

Steps to reproduce

Click on add or edit database.
Select existing database and open the folder dialog. Network drives do not appear in the list.

Operating system

Windows 10 64bit

SQLiteStudio version

3.4.6

[pawelsalawa]

Seems to be working here:

Do you see your shared drive on the list when you execute net use in your cmd?

[Sierron]

Sorry for the long delay. I checked with the old version and made sure that it was working fine beforehand and checked that the network drives are visible in the file explorer. And they are. I've used the old version today just fine with files on a network drive.

After updating however I get the yellow warning icon on the databases that are on a network drive. The database type is removed and when I try to check the path of the database the network drives are not visible.

[Sierron]

Seems to be working here: Do you see your shared drive on the list when you execute net use in your cmd?

And yes, running the command I can see the drives

[pawelsalawa]

It looks like your Windows is preventing SQLiteStudio from accessing this external drive.

Are you perhaps running this new version using some kind of compatibility emulation (that Windows built-in feature)? Or maybe you have a startup script that makes the SQLiteStudio run as different user? I don't know... but it doesn't seem to be issue with SQLiteStudio itself.

Have you tried running "portable" distribution of new SQLiteStudio version? (I assume you are currently using the "installer" based one?)

[Sierron]

So before I continue it's fixed now and I think I know why.

The installer needs to run as an admin and at the end there is a checked box saying open sqlitestudio. It looks like it opens it under admin user. And would you look at that:

I don't know why I didn't catch that earlier. Maybe I tried to open it as admin myself after the initial start with the installer and saw the same thing happening.

[pawelsalawa]

Good. By the way you should know, that using SQLite with shared/network files is not recommended. You may experience weird, unexpected results: https://www.sqlite.org/useovernet.html

[Sierron]

Thanks for the headsup and I am aware. Read that long time ago somewhere. My application isn't using network stored databases but rather I use sqlitestudio to edit these database files and the program/services run on the same machine as the databases. Unless SQLiteStudio is unreliable with that as well, there should be nothing to worry about for me.