I have 2 EXE's in the same computer accessing the same DB.
My connection code is as follows:
| Code: |
conAnyDAC1.Params.Clear;
conAnyDAC1.Params.CommaText := '"Database=' + lv_DBN + '"'
+ ',"SQLITE_DEFAULT_AUTOVACUUM=2"'
+ ',"SQLiteAdvanced=auto_vacuum = 1;page_size = 4096;temp_store = FILE;Journal_Mode = WAL;"'
+ ',"LockingMode=Normal"'
+ ',"Synchronous=Full"'
+ ',"DriverID=SQLite"';
conAnyDAC1.Connected := True;
|
The second EXE requests records from the DB the following error is generated:
[AnyDAC][Phys][SQLite] ERROR: database is locked.
Please advise...
The same connection settings are used during the create of the database.
TIA
