[firebird-support] Firebird 2.5 windows authentication and roles grants question?

2013-02-07 Thread marto94114
Hi guys, I `ve read all support docs included in firebird 2.5 installation together with several internet articals but I could not find a solution of the following problem I have: I am using firebird 2.5.1 x64 version on Windows Server 2008 R2 Enterprise. This machine is part of a domain

Re: [firebird-support] Firebird speed degrades during the day

2013-02-07 Thread Mark Rotteveel
On Wed, 06 Feb 2013 16:04:45 -, peter...@rocketmail.com peter...@rocketmail.com wrote: Hi, I have a customer with FB 1.56 sitting on SBS 2008 std and mostly xp clients. In certain areas of the program where activity is heaviest (server side procedures are being run to calculate the data) it

Re: [firebird-support] Re: Firebird speed degrades during the day

2013-02-07 Thread Carlos H. Cantu
Are you sure you ran gstat when things were already slow (as asked by Thomas)? Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br prc --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote: Hi, I have a

Re: [firebird-support] Some alternative to ZeBeDee?

2013-02-07 Thread Alexandre Benson Smith
Em 7/2/2013 04:04, W O escreveu: Hello everybody In some articles I saw that people use ZeBeDee for Internet communication with Firebird, however that product seems discontinued since the year 2005. Do you know another software similar to ZeBeDee which works well with Firebird and it's

[firebird-support] Re: restore a firebird 2.1 gbk in firebird 2.5

2013-02-07 Thread Christian Mereles
Hi, View the following: http://paulbeachsblog.blogspot.com.ar/2011/07/firebird-v21-error-value-exceeds-range.html Regards. -Christian- [Non-text portions of this message have been removed]

Re: AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

2013-02-07 Thread Gabor Boros
2013.02.07. 15:36 keltezéssel, Olaf Kluge írta: I am the first and only firbird user with this issue? What can I do? Thanks. I think no. ;-) In example: http://sourceforge.net/mailarchive/message.php?msg_id=23092682 Gabor

SV: [firebird-support] Scaling up Firebird-2.5.2.26539_0_x64.exe

2013-02-07 Thread Poul Dige
I came across this document: http://www.firebirdsql.org/file/documentation/papers_presentations/html /paper-fbent-impacting.html It seems to be talking about a much older version of FB than is available now. Even back in the days of Win 2003 Server, I've built systems that had probably

[firebird-support] Re: restore a firebird 2.1 gbk in firebird 2.5

2013-02-07 Thread Christian Mereles
Hi, En la db del ejemplo http://sourceforge.net/mailarchive/message.php?msg_id=23092682 The messages table has several timestamp fields, but the field (expired) is generating the error. Database: cabrweb.fdb, User: sysdba SQL select expired from messages; EXPIRED

Re: SV: [firebird-support] Scaling up Firebird-2.5.2.26539_0_x64.exe

2013-02-07 Thread Mark Rotteveel
On Thu, 07 Feb 2013 15:37:59 -, red_october2009 kevin.wendy.mor...@telus.net wrote: Hi Poul, At the bottom of your message you recommended both: If you use 2.5.2 you can run the super classic version, Are you recommending the super or the classic for the high number of concurrent

Re: SV: [firebird-support] Scaling up Firebird-2.5.2.26539_0_x64.exe

2013-02-07 Thread red_october2009
Doh! Thanks Mark. I install FB about once every 2 years... forgot about the 3 choices. ClassicServer SuperClassic SuperServer

[firebird-support] Help!

2013-02-07 Thread Mags Phangisa
Can someone please tell me what I am missing here? I just can't see what the problem is. insert into CTDC(CPYNO,CENNO,CONNO,REGDT,GRADE,GRDDT,STTUS,CPTUS,CIPDT,TAXDT,COIDT,BELVL,NHBDT)

Re: [firebird-support] Help!

2013-02-07 Thread Ted Miglautsch
You are missing the matching ) right before the ;. After VALUES you have a (. That needs a matching ). Mags Phangisa wrote: Can someone please tell me what I am missing here? I just can't see what the problem is. insert into

Re: [firebird-support] Help!

2013-02-07 Thread Mags Phangisa
Thanks. This is what happens when you work 18 hours non-stop. You start making silly errors. On Thu, Feb 7, 2013 at 6:59 PM, Ted Miglautsch mtm...@mail.ru wrote: You are missing the matching ) right before the ;. After VALUES you have a (. That needs a matching ). Mags Phangisa wrote:

AW: [firebird-support] Help!

2013-02-07 Thread Parzival
Hello, is the closing braket missing? Or is it a typo in the email? Niko Can someone please tell me what I am missing here? I just can't see what the problem is. insert into CTDC(CPYNO,CENNO,CONNO,REGDT,GRADE,GRDDT,STTUS,CPTUS,CIPDT,TAXDT,COIDT,BELVL ,NHBDT)

Re: [firebird-support] Help!

2013-02-07 Thread Ricardo Uzcategui
is missing the last ) On Thu, Feb 7, 2013 at 12:23 PM, Mags Phangisa magut...@gmail.com wrote: ** Can someone please tell me what I am missing here? I just can't see what the problem is. insert into CTDC(CPYNO,CENNO,CONNO,REGDT,GRADE,GRDDT,STTUS,CPTUS,CIPDT,TAXDT,COIDT,BELVL,NHBDT)

[firebird-support] Re: Ambiguous field names in selection statement errors on 2.5.1

2013-02-07 Thread cantak3
I did update this user to Firebird 2.5.2 but the problem persists. --- In firebird-support@yahoogroups.com, Mark Rotteveel wrote: On 5-2-2013 20:22, Paul R. Gardner wrote: Hi all, I have two tables that have some duplicated column names by design. The server is a Win2008 server. I

Re: [firebird-support] Some alternative to ZeBeDee?

2013-02-07 Thread W O
Thank you Karl. Thank you Alexandre. I shall try both of them. Greetings. Walter. On Thu, Feb 7, 2013 at 8:44 AM, Alexandre Benson Smith ibl...@thorsoftware.com.br wrote: ** Em 7/2/2013 04:04, W O escreveu: Hello everybody In some articles I saw that people use ZeBeDee for

Re: [firebird-support] Help!

2013-02-07 Thread Mags Phangisa
It was the bracket. My brain is toast, too tired. On Thu, Feb 7, 2013 at 7:04 PM, Parzival parzival1...@gmx.at wrote: ** Hello, is the closing braket missing? Or is it a typo in the email? Niko Can someone please tell me what I am missing here? I just can't see what the problem is.

Re: [firebird-support] Help!

2013-02-07 Thread Ricardo Uzcategui
jejeje. sure. i thinks it's a day to day thin On Thu, Feb 7, 2013 at 3:01 PM, Mags Phangisa magut...@gmail.com wrote: It was the bracket. My brain is toast, too tired. On Thu, Feb 7, 2013 at 7:04 PM, Parzival parzival1...@gmx.at wrote: ** Hello, is the closing braket missing? Or

[firebird-support] RDB$ADMIN and Role Revocation

2013-02-07 Thread Alan McDonald
I know in the past that the grantor must be the one who revokes that role. But now we have RDB$ADMIN a user with role RDB$ADMIN can create, edit and delete users and grant a role to another user. I would have thought SYSDBA or indeed any other RDB$ADMIN user could revoke any role. Firebird

Re: [firebird-support] RDB$ADMIN and Role Revocation

2013-02-07 Thread Paul Vinkenoog
Hi Alan, I know in the past that the grantor must be the one who revokes that role. But now we have RDB$ADMIN a user with role RDB$ADMIN can create, edit and delete users and grant a role to another user. I would have thought SYSDBA or indeed any other RDB$ADMIN user could revoke any role.

RE: [firebird-support] RDB$ADMIN and Role Revocation

2013-02-07 Thread Alan McDonald
Hi Alan, I know in the past that the grantor must be the one who revokes that role. But now we have RDB$ADMIN a user with role RDB$ADMIN can create, edit and delete users and grant a role to another user. I would have thought SYSDBA or indeed any other RDB$ADMIN user could revoke

Re: [firebird-support] RDB$ADMIN and Role Revocation

2013-02-07 Thread Paul Vinkenoog
Alan McDonald wrote: unsuccessful metadata update SYSDBA is not grantor of Role on MANAGER to 0S0ASDFASDF. You have to use GRANTED BY here: revoke manager from 0S0ASDFASDF granted by rdb$admin So we're saying SYSDBA has to first make system table enquiries to find out who

Re: [firebird-support] Script with 'Drop' in it

2013-02-07 Thread Paul Vinkenoog
Hello Todd, I would like to add a script that does a DROP EXTERNAL FUNCTION SQRT. The problem I have is that some of the databases that will run this script already have the UDF dropped and so the script errors. Is there a way to run statements like DROP INDEX, DROP EXTERNAL FUNCTION,