September 13th, 2013, 12:31 PM
2.5 Embedded file locking
In the 2.5 release notes its says, "The database file-lock that previously restricted connections to a single application space is replaced by a global lock table that allows simultaneous access to the same database from different embedded server modules." Which seams to be true most of the time for me. I am running this in windows and all processes accessing the database are using the same connection strings and fbembed.dll. There could be up to 4 different processes accessing the same database with the embedded module. For some reason on some machines one or more of the processes throws a file locked error, "Error+while+trying+to+open+file+--->+I/O+error+during+"CreateFile+(open)""
Am I reading this wrong? Under what circumstances would the embedded server lock the file? I am using version 220.127.116.11539.
It could be OS related because I have yet to be able to reproduce this on windows 7 but windows 2012 r2 and 2012 I have seen it happen with.
September 15th, 2013, 02:53 AM
Possibly you are mixing 32-bit and 64-bit client applications backed by Firebird Embedded. While it is true that you now can access one database by several Embedded processes, they all have to have the same bitness.