Zeoslib Portal

Hi all !

Is there any way to process DROP DATABASE command (in ZEOS 7.3) ?
I found some old tricks for CREATE DATABASE, but as I see source code for CreateNewDatabase trick - only isc_create_database call is expected

Possibly yes. But it never happened before with FB2.5 - I just had updated several instances to FB4 and got this problem. As the load is quite heavy, the problem appears after some hours of operation, maybe 6-12 hours. And together with the Reconnect problem is causes total fault. Once this error ap...

SVN version from last update (7807) Problem appeared with FB4 (4.0.1) and fbclient same version, x86 After some short time of operation with massive select, update, transactions, etc, an error appeared: Step 1 Error reading data from the connection.; GDS Code: 335544726; Code: -902 Message: IResultS...

Possibly this function can be called in different situations ?
But in this case the problem is - call to reconnect causes an exception and does not produce the result expected

What is really interesting, I see the following - try-except is commented here procedure TZAbstractDbcConnection.CloseRegisteredStatements; var I: Integer; begin for i := fRegisteredStatements.Count-1 downto 0 do begin //try IZStatement(fRegisteredStatements ).Close; //except end; end; end; Sample c...

Now I am back again. Seems the main problem is somewhere in transaction handling. If I run exactly the same code as I posted before - it works. But once I add forced transaction start and commit, it falls. Here's the updated code: ... Connection.Connect; Connection.StartTransaction; Query.SQL.Text :...

Hi ! Sorry for a long delay. I am currently with build 7741. Problem is still active. Once an #335544856 (connection shutdown) happens in Query.Open, I call to Connection.Reconnect - but it still fails when TZAbstractDbcConnection.Close CloseRegisteredStatements call. SQL Error: connection shutdown;...

Is there any solution for this problem ? Firebird driver seems to be totally non-functional in the current state, the only way for me is to throw it out and get back to older version...

This simpliest code shows the problem: program Project1; {$APPTYPE CONSOLE} {$R *.res} uses System.SysUtils, ZConnection, ZDataSet, ZDbcInterbase6Utils; var Connection: TZConnection; Query: TZQuery; begin try Connection := TZConnection.Create(nil); Connection.Protocol := 'firebird'; Connection.HostN...

Btw, It handles custom errors differently if they are "direct" or have dynamic parameters. That is a nightmare

raise exception myerror 'error'; -- OK
raise exception myerror 'error ' || aaa; -- FAILS getting error text

I had tried Reconnect - same situation. The problem is it's trying to close previous transaction that does not exists at the moment, so is raises an exception and function halts.

Sure, but anyway I should be able to force disconnect - this is not working, as I hang in exceptions cycle

Hi ! I still use firebird 2.5 and force disconnection to recompile stored procedures. Older ZEOS versions correctly report this situation, i.e. if I got a error code of 335544721, 335544722 and some more, I just did Connection.Close and Connection.Open to reconnect. Current version somehow reports d...

Quite possible I have a near problem. I have stored procedure with input parameter of type STRING, but it's internally handled for passing different types (i.e. bigint, float, etc). If I make a call select * from MYPROC(:VAL) with Query.ParamByName('VAL').AsLargeInt := 999; then on Query.Open I got ...

Have fresh ZEOS, just updated from SVN R7413, but same problem appeared with my previous archive valid for several months. Trying to execute DDL statement: create or alter procedure VERIFY_ADMIN2 ( ... some input declarations ...) returns ( ... some output declarations ...) as declare variable ... s...