Page 1 of 1

not connecting to sqlite db (file)??

Posted: 30 Sep 2017, 16:22
by m6var
Im getting the error log below. I have tested with Admin right on Log4OM.
I can open the sqlite file on the sqlite db editor with no problems, tables look ok.
Thank in advance.

2017-09-30 16:14:41.3492 INFO: Log4OMMainWindow: OPEN DATABASE by menu initiated
2017-09-30 16:14:44.1728 INFO: Log4OMMainWindow: OPEN DATABASE: \\Mac\Dropbox\m6var_log4om.SQLite
2017-09-30 16:14:44.1728 INFO: DatabaseManagement: *** Connecting to Database SqlLite ***
2017-09-30 16:14:44.1728 INFO: DatabaseManagement: SQLITE Begin Connection Validation
2017-09-30 16:14:44.1884 ERROR: *** DatabaseManagement: SQLITE Connection invalid ******* [Function: #=qhySAJ_wQFwyGX2q$P5UMDg==] 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 LogOM.BL.DatabaseManagement.#=qhySAJ_wQFwyGX2q$P5UMDg==(String #=qGPcDtmWvOqtTvU_baZLKlQ==)
2017-09-30 16:14:44.1884 INFO: SQLiteDatabaseManagement: Recalculating statistics...
2017-09-30 16:14:44.1884 INFO: Log4OMMainWindow: Statistics recalculated and refreshed

Re: not connecting to sqlite db (file)??

Posted: 01 Oct 2017, 10:59
by m6var
Im not sure if I have found the solution or a workaround...

Log4OM probably doesn't like 'network' locations and wants everything "mapped" on a drive letter. :?

Re: not connecting to sqlite db (file)??

Posted: 01 Oct 2017, 13:13
by G4POP
Are you storing the database on a Mac?