I'm having a problem with dynamic events and maybe someone can tell me what I'm doing wrong, or if this is a bug. My events contain the station number, date...
Hi, I want to install the Firebird 2.5 server through MSI Installer with logging options. Could you please provide the command line parameters for Firebird...
... Could you provide the relevant part of SHOW GRANTS in isql? ... In order for a procedure to execute successfully, it needs to have the rights to do its...
It's not a stand-alone tool like I think the MS SQL Profiler is, but Dev Art makes a tool called dbMonitor that takes input from a component you can create on...
Rick, ... I don't have a copy of SQL standard or the required decoder ring to make sense of it. My initial thinking was that was as expected, but in thinking...
118149
Rick Debay
rdebay@...
May 25, 2012 4:39 pm
A query with a left join to a table with a computed column returned values in the computed column even though the row didn't exist in the table. All other...
I would like to test the transition from 2.x to 2.5 on a backup machine we have. Am I correct in believing I can simply move the data files over and point the...
118146
Olaf Kluge
olaf.kluge@...
May 25, 2012 6:46 am
Hello Helen, Unfortunately, I have no success. and RDB$FIELD_NAME = ' || '"' || fname || '"'; string: NAME = "COLUMNNAME" ' result: Invalid token. Dynamic SQL...
... Missing a concat somewhere, it seems... stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = T_DT ...
118143
Newbie
netfirebird@...
May 24, 2012 5:01 pm
... Yes. I have FB 2.5 [Non-text portions of this message have been removed]...
... Have you provided the role name when connecting to the database? -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist ...
118141
Newbie
netfirebird@...
May 24, 2012 4:36 pm
I tried to grant execute permission for stored procedures for a role. but when this procedure is executed by a user in this role I get message, that rights...
... Still not enough apostrophes (I needed six apostrophes when I did my test, but I only used apostrophes around a constant and didn't use any concatenation...
118139
Olaf Kluge
olaf.kluge@...
May 24, 2012 4:01 pm
Hello, I have test it now. stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = T_DT and...
... Four isn't enough, add more! At least I wrote a simple stored procedure and MyStatement = 'SELECT ''''''Olaf Kluge'''''' FROM RDB$DATABASE'; EXECUTE...
118136
Olaf Kluge
olaf.kluge@...
May 24, 2012 1:54 pm
Hello, Unfortunately I have not yet found a solution to the problem. I use a String and would like to add a string-variable to the string. I need before and...
This machine uses a dedicated controller for RAID or uses OS? -> If using SO it will slow down the whole system. The RAID controller is with or without cache?...
Dear experts, I got following error after issuing SET statistics INDEX "RDB$INDEX_16" Error: GDS Exception. 335544351. unsuccessful metadata update MODIFY...
... Nope. :-) These files have just been copied from hard disk to hard disk and possibly from tape backup once (but that does NOT cause read only to be set)....
... Turns out it was reason 1. Feeling a bit silly now... Just can't imagine why I would have made these files read only. Oh well... Thanks! Kjell ... ...
Hello, Kjell! Wednesday, May 23, 2012, 6:15:29 PM, you wrote: KR> Engine Message: KR> no permission for read-write access to database 3 reasons possible: 1....
... Have you tried accessing the database with SYSDBA via isql? Then you can do a: show database; There you will see the owner of the database. -- With...
Hi, Trying to gain access to a couple of old FB 2.0 databases, I can't remember what username is set as database owner and has grants to access the database. ...
