Unable to open database file (0x800007FF)

1 Summary
2 Error
3 Cause
4 Solution

Summary

Connection to your SQLite database fails.

Initial situation:

You are trying to create a new SQLite database on your NAS (Network-Attached Storage).
Or your SQLite Performer Suite database is already located on your NAS.
Example path: \\nas0001\Software\PerformerSuite\Databases

The NAS is not intended for database access, so the performance will most likely be slow.
We recommend to use a central database: SQL Server

Error

System.Data.SQLite.SQLiteException (0x800007FF): unable to open database file

-------------------------
AppVersion: 23.2.0 - Branch:  - ChangeSet:  - ReleaseDate: 2023.11.9
2024.01.31|12:19:11
   at DevExpress.Xpo.DB.SQLiteConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.SQLiteConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.SQLiteConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at ProjectB.BusinessLogic.Providers.DatabaseProviders.DatabaseSelection.Intern.ConnectionDetails.ConnectionDetailsBase.TestConnection()
   at ProjectB.BusinessLogic.Providers.DatabaseProviders.DatabaseSelection.Intern.ConnectionTester.ConnectionTester.TestSqliteConnection(String userSelectDbFolderLocation, DbConnection connection)
Unable to open database. Connection string: 'Data Source=\\nas0001\Software\PerformerSuite\Databases\BiDatabase.db;'; Error: 'code = CantOpen (14), message = System.Data.SQLite.SQLiteException (0x800007FF): unable to open database file
   at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
   at System.Data.SQLite.SQLiteConnection.Open()
   at DevExpress.Xpo.DB.SQLiteConnectionProvider.CreateDataBase()'
-------------------------

Fehler beim Öffnen der Datenbank.

-------------------------
AppVersion: 23.2.0 - Branch:  - ChangeSet:  - ReleaseDate: 2023.11.9
2024.01.31|12:58:07

DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException
Message:
Unable to open database. Connection string: 'Data Source=\\Synology\Test\BiDatabase.db;'; Error: 'code = CantOpen (14), message = System.Data.SQLite.SQLiteException (0x800007FF): unable to open database file
   at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
   at System.Data.SQLite.SQLiteConnection.Open()
   at DevExpress.Xpo.DB.SQLiteConnectionProvider.CreateDataBase()'

Additional details:
   at ProjectB.Views.WPF.Wizards.NavigationViewModel`1.<ExecuteNext>b__55_1(Object sender, RunWorkerCompletedEventArgs args)
   at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.DispatcherOperation.InvokeImpl()
   at MS.Internal.CulturePreservingExecutionContext.CallbackWrapper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at MS.Internal.CulturePreservingExecutionContext.Run(CulturePreservingExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Threading.DispatcherOperation.Invoke()
   at System.Windows.Threading.Dispatcher.ProcessQueue()
   at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   at System.Windows.Window.ShowHelper(Object booleanBox)
   at System.Windows.Window.ShowDialog()
   at ProjectB.Views.WPF.Wizards.StartupErrors.StartupErrorWindow.ShowDialog(EError error)
   at ProjectB.Views.ProgramStartUp.OpenErrorDialog(EError error, IObjectMapper mapper)
   at ProjectB.Views.ProgramStartUp.CheckDatabase(IObjectMapper mapper)
   at ProjectB.Views.ProgramStartUp.Check(IObjectMapper mapper)
   at ProjectB.ClientDesktop.Program.Main(String[] args)


InnerException
unable to open database file

   at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
   at System.Data.SQLite.SQLiteConnection.Open()
   at DevExpress.Xpo.DB.SQLiteConnectionProvider.CreateDataBase()

-------------------------

Cause

Network paths beginning with "\\" are not supported for SQLite databases.

Solution

Map your network folder to a drive letter (see screenshot below)
Example: \\nas0001\Software\PerformerSuite to letter P:
1. Restart the Performer Suite
Now, in the Performer Suite, enter the database path: P:\Databases
Your connection should be successful.