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?


     Il Giovedì 13 Novembre 2014 17:48, "Thomas Steinmaurer 
[email protected] [firebird-support]" <[email protected]> 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





   

Reply via email to