Subject | RE: [firebird-support] Firebird problems |
---|---|
Author | Steffen Heil |
Post date | 2004-04-15T15:41:29Z |
Hi
First, there is nothing such as "embeded super server".
There is super server, wich allowes multiple connections and runs as
standalone software.
Then there is embeded server, wich is compiled into your application and
therefor only allows that application to access the database.
Independent of the version you use, you CAN NEVER access the same database
file using multiple engines. Therefor embeded server MUST lock the file.
Don't even try to change the code to allow non-exclusive access, it was done
that way for some reason. Accessing the same database with two engines will
destory it. Definitly.
One engine can never know what was changed by the other engine in RAM
already.
Use Super Server, NOT embeded for this.
Regards,
Steffen
First, there is nothing such as "embeded super server".
There is super server, wich allowes multiple connections and runs as
standalone software.
Then there is embeded server, wich is compiled into your application and
therefor only allows that application to access the database.
Independent of the version you use, you CAN NEVER access the same database
file using multiple engines. Therefor embeded server MUST lock the file.
Don't even try to change the code to allow non-exclusive access, it was done
that way for some reason. Accessing the same database with two engines will
destory it. Definitly.
One engine can never know what was changed by the other engine in RAM
already.
Use Super Server, NOT embeded for this.
Regards,
Steffen