RE: [firebird-support] Re: Another Error When Backup

2016-04-26 Thread 'Christine S' christine.sanj...@melawai.com [firebird-support]
Dear Vlad, Did you mean gfix –validate ? Yes I tried it, and there is no errors. Here is my memory test with dd command – the result of md5 is all same and no errors found : memtest2.jpg About running DDL, yes.. I actively alter table as is needed. Is this forbidden on live

Re: [firebird-support] FB 3.0 and PHP connection

2016-04-26 Thread 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]
which authentication method you are using on the server? Test with: Legacy Authentication If you do not intend to use SRP encrypted log-ins right away and want to use the security database—security3.fdb— as you have done in previous Firebird versions, proceed as follows: Using a text editor,

Re: [firebird-support] FB 3.0 and PHP connection

2016-04-26 Thread Kim Sandell sand...@celarius.com [firebird-support]
I had to copy the FBCLIENT.DLL from the Firebird installation directory to the Apache/bin directory for the PDO stuff to work. This however is dependent on your setup.  Also remember to use correct 32bit or 64bit version of the DLL, depending on your Apache. Regards, Kim From:

Re: [firebird-support] conect flamerobin with Firebird3

2016-04-26 Thread 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]
No I have not registered the dabtabase with the sysdba user. Even as I say connect and put the user who believes the database and gives me the same error as if flamerobin not respect the user with which I want to connect. This error does not occur in version 2.5.5 because the db is a restored

R: [firebird-support] Re: FB 3.0 and PHP connection

2016-04-26 Thread 'palbe...@libero.it' palbe...@libero.it [firebird-support]
Hi, also with this format I've got the same result (=NULL) :-( Best Regards Messaggio originale Da: r...@graficalc.nl [firebird-support] Data: 26/04/2016 17.03 A: Ogg: [firebird-support] Re: FB 3.0 and PHP

[firebird-support] Re: FB 3.0 and PHP connection

2016-04-26 Thread r...@graficalc.nl [firebird-support]
You could try separating the hostname from the database location (passing the hostname with host=). I have this: $conn = new PDO("firebird:host=$databasehost;dbname=$databasename;charset=utf8", $databaseuser, $databasepass);

[firebird-support] FB 3.0 and PHP connection

2016-04-26 Thread 'palbe...@libero.it' palbe...@libero.it [firebird-support]
Hi all, I'm working on the evaluation of Firebird SQL 3.0 and connection using PDO available in PHP. The database works fine and I'm able to connect it using FlameRobin but when I try to establish a connection using PHP I get a NULL as result of the follow: getMessage() . "";

Re: [firebird-support] conect flamerobin with Firebird3

2016-04-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-04-26 14:10, 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] wrote: > Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission Creating a role called SYSDBA will disallow the user SYSDBA to connect to Firebird. >

Re: [firebird-support] conect flamerobin with Firebird3

2016-04-26 Thread 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]
He does not work with the library version 2.5, but already configured to work with her. If I delete the SYSDBA role if I connect to the database, but do not want to eliminate that role. If I remove the role SYSDBA when connected and once connected beyond the role I think again you still

Re: [firebird-support] conect flamerobin with Firebird3

2016-04-26 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission > and when I try to connect from flamerobin you give me the following error > message > > *** IBPP::SQLException *** > Context: Database::Connect > Message: isc_attach_database failed >

Re: [firebird-support] How to get FB 3.0 x64 work as embeded version

2016-04-26 Thread InField.au infield...@outlook.com [firebird-support]
Thomas Dimitry, Thanks for all your reply. I am so silly to forget the configuration in compiler's option. Best regards, James

[firebird-support] Re: Another Error When Backup

2016-04-26 Thread hv...@users.sourceforge.net [firebird-support]
> ---In firebird-support@yahoogroups.com, wrote : Christine > > Did anyone ever face this error when gbak ? > > gbak: ERROR:internal Firebird consistency check (decompression overran > buffer (179), file: sqz.cpp line: 239) > gbak: ERROR:gds_$receive failed >

Re: [firebird-support] Another Error When Backup

2016-04-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.04.2016 11:51, whitebu...@gmail.com [firebird-support] wrote: > Any other solution so I wont missing 1 day data ? If you a lucky, disable garbage collection during backup. Otherwise you can use tools from www.ib-aid.com. Best of all - find reason of database corruption or reproducible

[firebird-support] Another Error When Backup

2016-04-26 Thread whitebu...@gmail.com [firebird-support]
Dear All, Did anyone ever face this error when gbak ? gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak: ERROR:gds_$receive failed gbak:Exiting before completion due to errors Here is firebird.log written :

Re: [firebird-support] How to get FB 3.0 x64 work as embeded version?

2016-04-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.04.2016 11:17, InField.au infield...@outlook.com [firebird-support] wrote: > But for x64 package, I got error like thi As a programmer you must know that bitness of a library has to match bitness of an application which address space it is loaded to. No exceptions from this rule. --

AW: [firebird-support] Sorting CTE for List()

2016-04-26 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello Set, thank you very much for your support! I was aware of the fact, that LIST() is unsorted, but I did not expect the problem I described in this posting. It works very nice. Thanks again Niko -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com

Re: [firebird-support] How to get FB 3.0 x64 work as embeded version?

2016-04-26 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hello James, > After FB 3.0 released, I am trying to immigrate my DB application to this new > version. > > > My DB app is running with embeded version before, so now I am still trying to > get it work under embeded mode. > I tried FB 3.0 x32, it works as embedded version well after I created a

[firebird-support] How to get FB 3.0 x64 work as embeded version?

2016-04-26 Thread InField.au infield...@outlook.com [firebird-support]
Dear Sir/Madam, After FB 3.0 released, I am trying to immigrate my DB application to this new version. My DB app is running with embeded version before, so now I am still trying to get it work under embeded mode. I tried FB 3.0 x32, it works as embedded version well after I created a new