Hello All.
I'm trying to learn mormot. I was able to compile and run successfully the first few samples. Now I want to test sample 30, specifically want to try working with an external Firebird database. (I've deployed a few apps with FB before). I was able to compile MVCServerFirebird, but then I get an error when running it:
An unhandled exception occurred at $00000001000FDDD6:
ESQLite3Exception: Error SQLITE_ERROR (1) [Step] using 3.35.5 - SQL Error: I/O e
rror during "CreateFile (open)" operation for file "MVCSERVERFIREBIRD.FDB"Error
while trying to open fileThe system cannot find the file specified. . Error Code
: -902. Unsuccessful execution caused by a system error that precludes successfu
l execution of subsequent statements, extended_errcode=1
$00000001000FDDD6 SQLITE3_CHECK, line 5400 of ../../../SynSQLite3.pas
$00000001000FD71E STEP, line 5320 of ../../../SynSQLite3.pas
$00000001000FC961 EXECUTE, line 4913 of ../../../SynSQLite3.pas
$00000001000FC9D3 EXECUTE, line 4933 of ../../../SynSQLite3.pas
$00000001000F99C8 EXECUTE, line 3999 of ../../../SynSQLite3.pas
$00000001002147F1 CREATEMISSINGTABLES, line 850 of ../../mORMotSQLite3.pas
$000000010000200F main, line 73 of MVCServerFirebird.dpr
$0000000100002206 main, line 103 of MVCServerFirebird.dpr
Tweaked a little in the code:
{$ifdef USEZEOSFIREBIRD}
aExternalDB := TSQLDBZEOSConnectionProperties.Create(
TSQLDBZEOSConnectionProperties.URI(dFIREBIRD,'127.0.0.1',
'bin\fbclient.dll'),
'MVCSERVERFIREBIRD.FDB','sysdba','masterkey');
aExternalDB.ThreadingMode := tmMainConnection; // as expected for FB embedded
{$endif}
System:
Laz 2.0.12
FPC 3.2.0
mORMot (grabbed it thru FPCupdeluxe using mORMot button)
Zeos 7.2.6 stable
Thanks.
jeffp