Version 10.0.4.0 64-bit installed on Citrix Terminal server and published as an app. On first run, the program pops up a dialog that says
====================
Unable to create database!
unable to create database file
OK
====================
When i open the data sources editor, I see one data source, "Local Data Source" the path is to my Citric appdata folder and the subfolder Devolutions\RemoteDesktopManager\Connections.db
When I click the Test Connection button, a dialog opens that just says "Failed."
I can browse to the location and see that there is a Connections.db file with a file size of 0. There is also a RemoteDesktopManager.log file which contains the following errors:
[10/21/2014 4:47:07 PM - 10.0.4.0 64-bit]ERROR System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
at System.Data.SQLite.SQLiteConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.FetchVersion()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.get_Version()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.get_IsUpgradeRequired()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.InitializeDatabase()
[10/21/2014 4:47:07 PM]ERROR SILENT System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
at System.Data.SQLite.SQLiteConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.FetchVersion()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.get_Version()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.get_IsUpgradeRequired()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.InitializeDatabase()
Could you try to specify the full path in the data source configuration?
David Hervieux
The full path is already specified in the dialog box. It was that way by default. Do you mean somewhere else?
It looks like this might be an issue with dll restrictions on Citrix preventing SQLite from running. It works fine with an XML database and I found a post from someone else having issues with SQLite on citrix:
http://lists.runrev.com/pipermail/use-livecode/2011-October/163647.html
You could setup a SQL Server Express and share the all sessions instead of using a SQLite database.
David Hervieux