Firebird in IBExpert throws errors while accessing

问题:

I am completely new to Firebird; I have been given a Firebird 2.5 database (by our client) - XYZ.fdb

I have registered this XYZ.fdb database in IB Expert.

I am able to run successfully some views and stored procedures. However for some other views or stored procedure, I get the following error:

can't format message 13:896 - message file C:Windows\firebird.msg not found; invalid request BLR at offset 623; function LTRIM is not defined; module name or entrypoint could not be found; Error while parsing procedure XXXXXXX (stored_procedure name) ;

Error Message:

Access violation at address 00DCA0E5 in module 'IBExpert.exe'. Read of address 00000000.

It was working fine last week; I had tried to restart the system, and install Firebird and IB expert over and over again; I get the above error for a few stored procedures and views, but the other views and stored procedures are working fine.

Since I did not have this issue last week, and in between I reinstalled Firebird and IB Expert a couple of times, I think it has some configuration or registration issue.

Can you provide me a step by step approach to fix this issue - such that I can access all database objects in the Firebird DB using IB Expert ?

回答1:

The resulting error might be created by an access violation from IBExpert, but the reason is definitely a missing UDF library, for example a .dll file called rfunc.dll or freeadhocudf.dll or whatever it is called.

To find the name of the missing .dll, check the UDFs used in the database by clicking on UDF folder in IBExpert database registration.