Error DB Sqlite db Error number 427264

Getting Started
1

Hi,
after upgrade to MacOS Sequoia 15.1.1 (from previous Sequoia version) i cannot use anymore a little App i’ve written.
Specifically the App opens but i receive Error DB: Sqlite db /users/myname/Library/Application Support/NiP:Nip.db: Error: “Unable to open database file” - Error number: 427264

The NiP.db file is in that position and i can open it using DBBrowser.
What could be the issue ?
Thanks

2

Have a look at the path of your db file - there is a : in the error message, if its not a typo you may have an error in the path to your db-file…

1 Like
4

Ohoh, yes your’re right so i’ve an error in my App, is it correct ? And the only way to solve is to rebuild it insert the correct path NiP/Nip.db, isn’t it ?
Actually i cannot insert the file using a name like: NiP:Nip.db …

5

Can you show us some code?
Are you using SpecialFolder.ApplicationData.Child("NiP/Nip.db")?
If so, try to change it to:
SpecialFolder.ApplicationData.Child("NiP").Child("Nip.db")

Looks like now your mac is looking for a file named "NiP/Nip.db" instead of a file named "Nip.db" in folder "NiP"

1 Like
6

Do not use a : or / as part of a filename.

1 Like
7

I’ve to reinstall Xojo, it’s a very old App that works without issue for a decad :slight_smile:
Is it possible that all happens only upgrading Mac OS Sequoia to 15.1.1 (from Sequoia 15.x) ?
Is it odd, isn’t it ?

To say the whole story … the App was created to be used with 2 scenario:

  • the first scenario in a shared folder using Valentina Server: in this case the database is correctly opened and i don’t receive any error message but it’s a week that seems suddenly empty … but when i open it using DBBrowser the data are correctly there, and don’t know how to solve that
  • so i tryed to use the second scenario (of this post) changing the path and work locally, i moved the file locally but i receive the error i’ve said
    Any hints without need to reinstall Xojo ?
8

Here’s the part of the code used:

Var dbFile As FolderItem = SpecialFolder.ApplicationData.Child(“NiP/NiP.db”)
DB.DatabaseFile = dbFile

9

No reason to uninstall/reinstall Xojo.
Take @AlbertoD’s advice and change to:

SpecialFolder.ApplicationData.Child("NiP").Child("Nip.db")```
2 Likes
10

Sorry may you please elaborate it ?
How to do it ?
In terminal ?

11

I don’t have Xojo installed anymore on my Mac …

12

ok now I understand.
Yes the code must be changed and then recompiled to create app for the Mac