[solved] Error openning Database
lazarus / 16-Databases

----------------------------------------------------------------------
DeBritto · 2017-12-17 18:34

Hi Folks,
I'm using this routine to connect to a database (SQLdb + Firebird
3.0):

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i // Local
ServerIBConnection_ConnSmCube.DatabaseName:= GetCurrentDirUTF8 +
DirectorySeparator + 'SMCUBE.FDB';IBConnection_ConnSmCube.UserName:=
'SYSDBA';IBConnection_ConnSmCube.Password:=
'masterkey';IBConnection_ConnSmCube.HostName:= '';
//'localhost';IBConnection_ConnSmCube.CharSet :=
'UTF8';IBConnection_ConnSmCube.Dialect :=
3;IBConnection_ConnSmCube.Transaction:= SQLTransaction_ConnSmCube;IBCo
nnection_ConnSmCube.Transaction.Params.Text:='isc_tpb_read_committed';
// Allow me to see all commited data try 
IBConnection_ConnSmCube.Connected:= True;except 
ShowMessage('Connection Failed!');  Application.Terminate;end;//
Activate Transaction CompomentSQLTransaction_ConnSmCube.DataBase:=
IBConnection_ConnSmCube;SQLTransaction_ConnSmCube.Active:= True;
The problem is that I cannot open the database if it is already open
by another program:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
IBCOnnection_ConnSmCube: DoInternalConnect:-I/O error during
"CreateFile (open)" operation for file
"C:\USERS\CHRISTIAN\ONEDRIVE\PUBLIC\SMCUBE.FDB"- Error while trying to
open file- The file is already in use by another process.
What am I doing wrong?
Best regards

----------------------------------------------------------------------
taazz · 2017-12-17 22:37

QuoteStarting with Firebird 2.5, Firebird Embedded on Windows behaves
like the SuperClassic server model, which means it uses shared access
to the database files, and that the same database can be accessed by
multiple Firebird Embedded applications and Firebird servers in the
Classic or SuperClassic server model (but not SuperServer) if they are
running on the same machine. The downside of this change is that
embedded applications need to be able to create, read and write the
shared database lockfiles (in C:\ProgramData\Firebird).source
https://stackoverflow.com/questions/32902746/connect-from-multiple-
applicatons-to-one-firebird-database-via-embedded-dll

Starting with firebird 3 the embedded dll and fbclient dll where
merged in to one dll the connection properties you shown will trigger
the embedded mode.

----------------------------------------------------------------------
rvk · 2017-12-17 22:58

And using a database directly in a directory on ONEDRIVE might also be
a bad idea. It's asking for trouble.

----------------------------------------------------------------------
DeBritto · 2017-12-18 18:08

Hi,
Thank you Taazz, It's working now. I changed "c:/program
Files/Firebird" permissions

Thanks for the tip rvk

Best regards