> I have different software connected to db: > 1. Delphi + IB_Object/IBO2. Web/WCF + NHibernate + Firebird ADO.NET3. Winforms > + Firebird ADO.NET 4. DB Access (linked to firebird with external table) + > ODBC > It is possible that a data connection change write mode?
Yes. In your IBO application, what is the value of TIB_connection.ForcedWrites? I vaguely remember a bug there in the connection design editor flipping the property explicitely to False although "Default" is the default and recommended value for that. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Il Giovedì 13 Novembre 2014 17:48, "Thomas Steinmaurer > t...@iblogmanager.com > [firebird-support]" <firebird-support@yahoogroups.com> ha scritto: > > > > *UPDATE* >> I have changed batch, switch -online before change write mode. >> Actually the batch is: >> "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE% >> "%FB_PATH%\GFIX.EXE" -shut full -force 0 -user SYSDBA -password >> masterkey %DB1% >> %LOG_FILE% >> "%FB_PATH%\GFIX.EXE" -online normal -user SYSDBA -password masterkey >> %DB1% >> %LOG_FILE% >> "%FB_PATH%\GFIX.EXE" -write sync -user SYSDBA -password masterkey %DB1% >> >> %LOG_FILE% >> "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE% >> >> From log file it's all ok: >> >> ######## 2014_11_13 3.30.50,84 >> [...] >> Next header page 0 >> Database dialect 3 >> Creation date Aug 19, 2014 21:56:08 >> Attributes >> >> Variable header data: >> Sweep interval: 20000 >> *END* >> >> <after gfix -write sync> >> [...] >> Page buffers 0 >> Next header page 0 >> Database dialect 3 >> Creation date Aug 19, 2014 21:56:08 >> Attributes force write >> >> Variable header data: >> Sweep interval: 20000 >> *END* >> >> >> But actually force write is off: >> >> ######## 2014_11_13 10.45.33,75 >> [...] >> Implementation ID 16 >> Shadow count 0 >> Page buffers 0 >> Next header page 0 >> Database dialect 3 >> Creation date Aug 19, 2014 21:56:08 >> Attributes <<<<<<<<<<<<<< >> >> Variable header data: >> Sweep interval: 20000 >> *END* >> >> >> How is possible? Any idea? Firebird versione is 2.5.3 on Windows >> Standard Server 2008. > > What data access technology are you using? > > > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird > FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > > > >
