[firebird-support] fbtrace - linux server

2013-03-13 Thread castel.m
Hello, I used trace audit in de services menu of IBexpert with a windows firebird server and it works great ! Now, i wanted to trace a database on a linux firebird 2.5 server but i get nothing in de trace screen. I also tried with the trial version of FB tracemanager 2, but I see nothing

Re: [firebird-support] fbtrace - linux server

2013-03-13 Thread Thomas Steinmaurer
Am 13.03.2013 um 08:54 schrieb caste...@titelive.be: Hello, I used trace audit in de services menu of IBexpert with a windows firebird server and it works great ! Now, i wanted to trace a database on a linux firebird 2.5 server but i get nothing in de trace screen. I also tried

Re: [firebird-support] fbtrace - linux server

2013-03-13 Thread Konstantin Khomoutov
On Wed, 13 Mar 2013 08:54:58 +0100 caste...@titelive.be wrote: I used trace audit in de services menu of IBexpert with a windows firebird server and it works great ! Now, i wanted to trace a database on a linux firebird 2.5 server but i get nothing in de trace screen. I also tried with

RE: [firebird-support] fbtrace - linux server

2013-03-13 Thread castel.m
Hi, Thanks Konstantin, Sorry for the darkness ... :-) Yes The server is a debian, just checked the version : 6.0.7 , that's a Squeeze and the firebird package was installed from the debian depot. Just checked firebird log file, and found this message : (not exactly the same as the one you gave

[firebird-support] Firebird Embedded 2.5.2 with vb.net (visual studio 2010)

2013-03-13 Thread JamesFraley
ALCON, I'm trying to use Firebird Embedded 2.5.2 with vb.net on Windows 7 (64bit). I create a Visual Basic program and copy the dll into the working directory. When I try to add a reference to the gdc32.dll, I get the following error message: A reference to 'd:\vb4\gdc32.dll' could not be

Re: [firebird-support] fbtrace - linux server

2013-03-13 Thread Konstantin Khomoutov
On Wed, 13 Mar 2013 11:28:26 +0100 caste...@titelive.be wrote: Thanks Konstantin, Sorry for the darkness ... :-) Yes The server is a debian, just checked the version : 6.0.7 , that's a Squeeze and the firebird package was installed from the debian depot. Just checked firebird log file, and

RE: [firebird-support] fbtrace - linux server

2013-03-13 Thread castel.m
This is my fbtrace.conf : database /var/databases/mlv2_ps4t.fdb enabled true log_connections true log_transactions true log_statement_start true /database used with the command : fbtracemgr -se localhost/3050:service_mgr -user XXX -password xxx -start -name

[firebird-support] Re: fbtracemgr and embedded

2013-03-13 Thread hvlad
--- In firebird-support@yahoogroups.com, certfb wrote: ... Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10. It is still not clear which process handle database connection - your application's embedded attachment or worker process of Firebird CS. I have set up fbtracemgr to

[firebird-support] Re: Catching exception fails under isql

2013-03-13 Thread hvlad
--- In firebird-support@yahoogroups.com, Rick Debay wrote: I think it's a 1.5 bug, as executing the procedure from DBW also fails no current record for fetch is well-known optimizer bug and in some form exists even in latest Firebird versions. Usually it happens when one mixed two kind of

RE: [firebird-support] fbtrace - linux server

2013-03-13 Thread castel.m
After reading this : http://tracker.firebirdsql.org/browse/CORE-3447 And seen : Fix Version/s: 2.5.1, 2.1.5, 3.0 Alpha 1 at the top of the page, we installed firebird2.5-backports. That's Firebird Version: 2.5.1.26351 And now it works. Thanks for your help Konstantin. Marianne Castel

RE: [firebird-support] Re: Catching exception fails under isql

2013-03-13 Thread Rick Debay
Changing the catch block: WHEN /*GDSCODE unique_key_violation*/ ANY DO Allows us to work around the problem. no current record for fetch is well-known optimizer bug and in some form exists even in latest Firebird versions. Usually it happens when one mixed two kind of JOIN syntax (implicit and

[firebird-support] Re: Catching exception fails under isql

2013-03-13 Thread hvlad
--- In firebird-support@yahoogroups.com, Rick Debay wrote: Changing the catch block: WHEN /*GDSCODE unique_key_violation*/ ANY DO Allows us to work around the problem. This is not a mine deal of course, but this is VERY BAD. Hiding exceptions is a *very bad* practice. But this is your

[firebird-support] Using Firebird SuperClassic and Embedded (SC) v2.5 on same server

2013-03-13 Thread Leyne, Sean
Although this question is probably better asked on the devel list, I am asking it here since other might benefit from the discussion. I am thinking of deploying both an 'standard' and embedded SuperClassic engine on client systems, and wonder what configuration/issues I need to know about. The

Re: [firebird-support] Using Firebird SuperClassic and Embedded (SC) v2.5 on same server

2013-03-13 Thread Carlos H. Cantu
LS Although we deploy standard server installs, there are times when LS we need to ensure that no external connections (ODBC) can connect LS to local databases while we perform database maintenance. Can't you just put the database in single shutdown mode before doing the maintenance? PS: I'm

RE: [firebird-support] Using Firebird SuperClassic and Embedded (SC) v2.5 on same server

2013-03-13 Thread Leyne, Sean
Carlos, LS Although we deploy standard server installs, there are times when we LS need to ensure that no external connections (ODBC) can connect to LS local databases while we perform database maintenance. Can't you just put the database in single shutdown mode before doing the

RE: [firebird-support] Using Firebird SuperClassic and Embedded (SC) v2.5 on same server

2013-03-13 Thread Helen Borrie
At 09:25 a.m. 14/03/2013, Leyne, Sean wrote: External applications use a normal users, our internal applications use SYSDBA. We want to even control our own applications from accessing the database (our apps are services, so a remote admin could naively start the service, when we are doing

Re: [firebird-support] Re: fbtracemgr and embedded

2013-03-13 Thread Mike Ro
Dear Vlad, thank you for your response and insight. Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10. It is still not clear which process handle database connection - your application's embedded attachment or worker process of Firebird CS. For the first testing I have

Re: [firebird-support] Using Firebird SuperClassic and Embedded (SC) v2.5 on same server

2013-03-13 Thread Carlos H. Cantu
LS External applications use a normal users, our internal LS applications use SYSDBA. We want to even control our own LS applications from accessing the database Single shutdown mode allows only one connection (from SYSDBA or OWNER), so if you are able to assure that your maintenance app will

Re: [firebird-support] Instalar FB SS 2.5.2 apt_get ou arquivo FirebirdSS-2.5.2.26539-0.i686.tar.gz

2013-03-13 Thread Carlos H. Cantu
Você deve enviar suas dúvidas para a lista internacional de suporte **EM INGLÊS**. Para suporte em português, sugiro a lista da FireBase. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br p Estou instalando o Firebird SS