Re: [Firebird-devel] SP crashing server

[Fabiano B. <fa...@pe...>]

Milan Babuskov escreveu:
> Fabiano Bonin wrote:
>> Ops, maybe it's a IBExpert issue. It seems it runs OK in isql.
>> Maybe someone want to give it a try.
> 
> Are you using the same connection string in both tools?
> 
> 
> I just tried with FlameRobin (against Classic Server). Firebird didn't 
> crash, but I got this:
> 
> Message: isc_dsql_fetch failed.
> 
> SQL Message : -501
> The cursor identified in a FETCH or CLOSE statement is not open.
> 
> Engine Code    : 335544327
> Engine Message :
> invalid request handle
> 
> 

You got a point here!

If i connect with isql using the same string, the error appears:

[root@servidor clientes]# isql 127.0.0.1:/share/clientes/trevilub.fdb 
-user sysdba -pass ????????
Database:  127.0.0.1:/share/clientes/trevilub.fdb, User: sysdba
SQL> select * from sp_record_count(null);

TABLE_NAME                      RECORD_COUNT
=============================== ============
Statement failed, SQLCODE = -902

Error reading data from the connection.