AW: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
I forgot.. may you have also to update to version 3.0.1!


 


Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Mittwoch, 26. Oktober 2016 15:33
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Unable to upgrade database to firebird 3.0


 


  


Hello All,


   Recently I upgraded my Firebird from 2.5 to 3.0 and I am using 'EMS
SQL Manager Interbase/Firebird'  to connect and work with database.  Now
whenever I connect existing database or register a new database I get
following error 


 Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.


Error loading plugin Engine12.


Module C:\Program Files\Firebird\Firebird_3_0\plugins/Engine12 exists but
cannot be loaded.


 


SQL Code: -901


IB Error Number: 335545004


 


   I visited EMS website and found there latest version supports
upto Firebird 2.5 . Could someone suggest another method to connect to
database. 


 


Thanks in advance.


 


With Regards,


Joje T. George

AW: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Hello Joje


 


I hade the same problem


 


You have to choose the client library from a other directory than <
c:\program files\firebird\firebird_3_0 >


 


May you choose 


 


You have to set this in the Host Registration Info under the register
connection / client library!


 


 


Best Regards


Gregor


 


 


Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Mittwoch, 26. Oktober 2016 15:33
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Unable to upgrade database to firebird 3.0


 


  


Hello All,


   Recently I upgraded my Firebird from 2.5 to 3.0 and I am using 'EMS
SQL Manager Interbase/Firebird'  to connect and work with database.  Now
whenever I connect existing database or register a new database I get
following error 


 Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.


Error loading plugin Engine12.


Module C:\Program Files\Firebird\Firebird_3_0\plugins/Engine12 exists but
cannot be loaded.


 


SQL Code: -901


IB Error Number: 335545004


 


   I visited EMS website and found there latest version supports
upto Firebird 2.5 . Could someone suggest another method to connect to
database. 


 


Thanks in advance.


 


With Regards,


Joje T. George

[firebird-support] Calculating Transaction Inventory Pages (TIP)

2016-10-24 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Hello


 


I found a formula to calulate the TIP size


 


(Next Transaction - OIT) / (4 transactions per byte


*  (1024 bytes - 16 byte header - 4 byte next TIP page number))


 


This should be valid vor Server 2.1 and 2.5.


 


Is it also valid for Server 3.0? Are the roules 4 transaction per byte also
valid at FB3 ?


 


Thanks and Best Regards


Gregor

AW: AW: [firebird-support] High number of NULL attachments

2016-10-04 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
OK, but are the version of the bundled (client) dll compared to the dll
comes with FB2.5.3 are the same?


 


Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Dienstag, 4. Oktober 2016 11:39
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] High number of NULL attachments


 


  


fbclient.dll is bundled with the client application.


-Tom


On Tue, October 4, 2016 10:14 am, 'Gregor Kobler'  
g...@gksoft.ch
[firebird-support] wrote:
> Does the Client uses the right fbclient.dll or GDS32.dll?
>
>
>
>
>
> Best Regards
>
>
> Gregor
>
>
>
>
>
> Von: firebird-support@yahoogroups.com
 
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Dienstag, 4. Oktober 2016 08:41
> An: firebird-support@yahoogroups.com
 
> Betreff: [firebird-support] High number of NULL attachments
>
>
>
>
>
>
>
>
> Hi all.
>
>
> I am running a FB 2.5.3 server to which a delphi application connects. We
> usually have 20-30 concurrent connections.
> I have inspected the MON$ATTACHMENTS table and noticed many of the records
> have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
> MON$REMOTE_ADDRESS.
>
>
> Does that mean that the connection to the server is still open even if the
> application isn't? How can I mitigate that?
> Thanks.
>
>
> -Tom
>
>
>
>
>
>
>

AW: [firebird-support] High number of NULL attachments

2016-10-04 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Does the Client uses the right fbclient.dll or GDS32.dll?





Best Regards


Gregor





Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 4. Oktober 2016 08:41
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] High number of NULL attachments








Hi all.


I am running a FB 2.5.3 server to which a delphi application connects. We
usually have 20-30 concurrent connections.
I have inspected the MON$ATTACHMENTS table and noticed many of the records
have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
MON$REMOTE_ADDRESS.


Does that mean that the connection to the server is still open even if the
application isn't? How can I mitigate that?
Thanks.


-Tom

AW: [firebird-support] Access Violation Memory From IBEXPERT

2016-10-03 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
May you have to ask this question tot he support of ibexpert!


 


Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Montag, 3. Oktober 2016 05:35
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Access Violation Memory From IBEXPERT


 


  


Dear All, 


 


Have you guys ever seen this kind of error message while accessing data from
ibexpert ? What should I do when seeing this error ? 


I tried to backup and restore the database. I still cannot access the
records from ibexpert. 


 


Error Message:





Access violation at address 0094CD3C in module 'ibexpert.exe'. 


Read of address EB481408


 


Access violation at address 0094CD3C


 


Regards, 


Christine Sanjaya

AW: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Follow the link to the missing picture!


http://screencast.com/t/EKQeG7QRqBS











Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Samstag, 17. September 2016 12:33
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table








16.09.2016 09:02, 'Gregor Kobler'wrote:
>
> When you querying the MON$STATEMENTS table, the active statements are
> not shows a transaction-id and not a timestamp, These columns are allwas
> Zero / NULL!


Transaction ID and timestamp are reported only for active statements,
they're NULL for idle ones. You've said that MON$STATE = 0, so your
statements are idle, not active.


Dmitry

AW: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Ok thanks for explaining me


-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Montag, 19. September 2016 11:52
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Re: AW: Problem querying MON$STATEMENTS

table


19.09.2016 10:45, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote:
> When i monitor the MON$STATEMENTS table for a while, i didn’t see a state
1 on any statemens.


   In single connection workload you won't see any active statements except
the current one.




--
   WBR, SD.










++


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

AW: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Hello Dimitry





May i didn’t understand something not correct, but look below









In that excaple, i have 2 open tables «MON$STATEMENTS» and «HORNCODE»





The ID #228 are the Statement for the table «MON$STATEMENTS» and shows a 
transaction id and a timestamp the State are 1 (active) correctly.





The ID #192 shows the statements fort he second open table «HORNCODE», but 
there are the state 0 (idle).





Why shows the #228 a state 1 and the #192 a zero??





When i monitor the MON$STATEMENTS table for a while, i didn’t see a state 1 on 
any statemens. I see just zero’s or two’s (stalled)





may I make a consideration error





Best Regards


Gregor








Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Samstag, 17. September 2016 12:33
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table









16.09.2016 09:02, 'Gregor Kobler'wrote:
>
> When you querying the MON$STATEMENTS table, the active statements are
> not shows a transaction-id and not a timestamp, These columns are allwas
> Zero / NULL!


Transaction ID and timestamp are reported only for active statements,
they're NULL for idle ones. You've said that MON$STATE = 0, so your
statements are idle, not active.


Dmitry










[Non-text portions of this message have been removed]

WG: [firebird-support] Problem querying MON$STATEMENTS table

2016-09-16 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Hello Dimitry


Sorry, but the link was broken. Follow the correct link
http://screencast.com/t/ptp6Sj2JW


Best Regards
Gregor


-Ursprüngliche Nachricht-
Von: Gregor Kobler [mailto:g...@gksoft.ch]
Gesendet: Freitag, 16. September 2016 15:10
An: 'firebird-support@yahoogroups.com' <firebird-support@yahoogroups.com>
Betreff: AW: [firebird-support] Problem querying MON$STATEMENTS table


Hello Dimitry


I have prepeard a video where i show you what i mean.


http://screencast.com/t/GfeDBgiopzzG


I made a mistake, this problem is happend to version 2.5.5.26952 /
2.5.6.27020 and also to 3.0.1.32591 (where i have tested)


Best Regards
Gregor


-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 16. September 2016 10:47
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Problem querying MON$STATEMENTS table


16.09.2016 8:02, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote:
> When you querying the MON$STATEMENTS table, the active statements are
> not shows a transaction-id and not a timestamp, These columns are allwas
Zero / NULL!


   Can you prepare isql script that demonstrate the problem?




--
   WBR, SD.










++


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

AW: [firebird-support] Problem querying MON$STATEMENTS table

2016-09-16 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Hello Dimitry


I have prepeard a video where i show you what i mean.


http://screencast.com/t/GfeDBgiopzzG


I made a mistake, this problem is happend to version 2.5.5.26952 /
2.5.6.27020 and also to 3.0.1.32591 (where i have tested)


Best Regards
Gregor


-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 16. September 2016 10:47
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Problem querying MON$STATEMENTS table



16.09.2016 8:02, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote:
> When you querying the MON$STATEMENTS table, the active statements are
> not shows a transaction-id and not a timestamp, These columns are allwas
Zero / NULL!


   Can you prepare isql script that demonstrate the problem?




--
   WBR, SD.










++


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

AW: [firebird-support] Problem querying MON$STATEMENTS table

2016-09-16 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support] 
Hello Hellen


 


The Problem are not on the server 3.0.1, this is working well!! The problem
are on the server 2.5.5.26952 and 2.5.6.27020!


 


When you querying the MON$STATEMENTS table, the active statements are not
shows a transaction-id and not a timestamp, These columns are allwas Zero /
NULL!


 


I'm programing a Program thats shows whats going on in the monitoring
tables, and yesterday i realized that the active statements are not showed.
This problem also existst with the Sinatica-Monitor (may you now this
software)


 


Best Regards


Gregor


 


 


Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 16. September 2016 03:47
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Problem querying MON$STATEMENTS table


 


  


Friday, September 16, 2016, 12:02:28 AM, Gregor Kobler wrote:


> I have a problem when i querying the MON$STATEMENS table on Server 2.5.5
and also 2.5.6
>
> Do the follow steps:
> 
> Open a connection to the database, then start a transaction an open
> a table to show the content and keep it open/active Now run the
> follow statement "SELECT * FROM MON$STATEMENS"
> 
> The Row that should shows you the active query are not correct!
Open output set <> active query.
Once the SELECT statement has finished fetching, its state is no
longer active...it becomes "idle".
> 
> The column MON$STATE shows allways Zero
Zero is the "idle" state. It will go to "active" (1) next time the
cursor restarts.


> and also the columns
> MON$TRANSACTION_ID and MON$TIMESTAMP are also allways NULL!!


Both of those fields will hold values only while the statement is
active. A statement that is idle is not active.
> 
> The Server 3.0.1 are not affected on this problem.
>
> The follow databases with charset are not working (tested) NONE, WIN1250,
ISO8859_1
> 
> A database with charset WIN1251 are working well.
>
> May this could be a bug.


If you suspect a bug, please try to give a proper description of what
you mean by "working well" and "not working" and post it, with your
statements, to firebird-devel. Also give the build number of the
snapshot that you refer to as "Server 3.0.1", as these snapshots are
refreshed very regularly.


The core devs have been working pretty solidly on Fb3 bugs over the
past 3 months so you should be able to discover what kind of a problem
(if any) you are actually observing and whether it is fixed.


HB