Odp: [firebird-support] Re: MON$STATEMENTS - RDB$STATEMENT_ID - Integer?

2014-01-03 Thread liviusliv...@poczta.onet.pl
Hi, If it is automatically restarted even persistent connections exists then i see no problem. We do not have queries open for month ;-) I ask because i am warried that this work in the same way as transaction id - after reach max int system stop and only backup restore can help. But here we

Re: [firebird-support] Unable to connect to data source: library #39;gds32.dll#39; failed to load

2014-01-03 Thread Mark Rotteveel
On 2-1-2014 20:02, bandersn...@gmail.com wrote: My PC was changed to Windows 7 64-bit. And I'm back in the same hole... My Environment: * Client PC is Windows 7 64-bit * Client code is Perl 64-bit * ODBC FB Driver 2.0.2 64-bit dated 7/8/2013 I loaded the ODBC Driver, and its listed

[firebird-support] SelectQuery: Unsuccessful executio

2014-01-03 Thread alessandroyamasaki
Good Day Someone already passed the issue below: 'SelectQuery: Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements. Error reading data from the connection.' I'm using Firebird 2.5 and Delphi 7 Some hint of what might be? Thanks

Re: [firebird-support] SelectQuery: Unsuccessful executio

2014-01-03 Thread Thomas Steinmaurer
Good Day Someone already passed the issue below: 'SelectQuery: Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements. Error reading data from the connection.' I'm using Firebird 2.5 and Delphi 7 Some hint of what might be? Usually,

Re: [firebird-support] Field identification procedure

2014-01-03 Thread Mark Rotteveel
On 31-12-2013 11:25, Virna Constantin wrote: Hello, I built a procedure that returns me: - TAB_CMP ('MYTABLE', '') type and number of fields of table or - TAB_CMP ('MYTABLE, 11) name fields and the size of field id but I have the following problem, in the table RDB$RELATIONS the field

Re: [firebird-support] Re: Full Cross Tab but unknown column headers

2014-01-03 Thread Venus Software Operations

[firebird-support] FB 2.5 and SQL Message : -607,This operation is not defined for system tables.

2014-01-03 Thread Luigi Siciliano
Hallo, The subsequent SQL Code is accepted in FB 2.1 but not in FB 2.5: - SET TERM ^ ; CREATE OR ALTER TRIGGER AA_CEDOLINI FOR CEDOLINI ACTIVE AFTER INSERT OR UPDATE OR DELETE POSITION 0 AS BEGIN /* รจ */ END^ SET

Re: [firebird-support] SelectQuery: Unsuccessful executio

2014-01-03 Thread Mark Rotteveel
On 3-1-2014 14:09, Thomas Steinmaurer wrote: Good Day Someone already passed the issue below: 'SelectQuery: Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements. Error reading data from the connection.' I'm using Firebird 2.5 and

Re: [firebird-support] FB 2.5 and SQL Message : -607,This operation is not defined for system tables.

2014-01-03 Thread Mark Rotteveel
On 3-1-2014 15:32, Luigi Siciliano wrote: Hallo, The subsequent SQL Code is accepted in FB 2.1 but not in FB 2.5: - SET TERM ^ ; CREATE OR ALTER TRIGGER AA_CEDOLINI FOR CEDOLINI ACTIVE AFTER INSERT OR UPDATE OR

Re: [firebird-support] FB 2.5 and SQL Message : -607,This operation is not defined for system tables.

2014-01-03 Thread Luigi Siciliano
Il 03/01/2014 15.50, Mark Rotteveel ha scritto: Works fine for me using FlameRobin on FB 2.5.2 Update 1, connection character set UTF-8. What is your connection character set, and how are you executing this? Mark FB Server = 2.5.2.26540 Default Character set = NONE I tried with: 1)

Re: [firebird-support] Unable to connect to data source: library #39;gds32.dll#39; failed to load

2014-01-03 Thread bandersnoot
I started odbcad in system32 and syswow64 and they both show ODBCFB.DLL for Firebird. I see there is a OdbcFb.dll in System32. I moved gds32.dll into SysWOW64 and the Perl client crashes immediately after trying to connect. I remove gds32.dll from SysWOW64 and it still crashed. I

[firebird-support] firebird-support-subscr...@yahoogroups.com

2014-01-03 Thread quanphamkt
I created a table in Firebird 2.5 with the following code: CREATE TABLE DMSV (MASV CHAR(8) CHARACTER SET ASCII NOT NULL, TENSV VARCHAR(120) CHARACTER SET UTF8 NOT NULL, LOP CHAR(10) CHARACTER SET ASCII NOT NULL, SDT VARCHAR(11)CHARACTER SET ASCII NOT NULL, EMAIL VARCHAR(100) CHARACTER SET

[firebird-support] RE: Full Cross Tab but unknown column headers

2014-01-03 Thread venussoftop
Hi Set I just upgraded to FB 2.5.2.26540 and tried the EXECUTE BLOCK again but had the same issues: Starting transaction... Preparing statement: EXECUTE BLOCK returns (Mystatement varchar(1)) AS DECLARE VARIABLE S VARCHAR(256) Error: *** IBPP::SQLException *** Context: Statement::Prepare(

[firebird-support] Roles - Permissions - RDB$ADMIN

2014-01-03 Thread Alan McDonald
Users with RDB$ADMIN granted to them have the ability to creates users. They can, of course, also grant other roles to users. But they cannot revoke roles already granted to a user by another RDB$ADMIN or SYSDBA since the RDB$GRANTOR is always a user not a role. Does anyone know a way to