IBExpert中的Firebird在访问某些存储过程时抛出错误 [英] Firebird in IBExpert throws errors while accessing some stored procedure

问题描述

我对Firebird是全新的，我已经给了一个Firebird 2.5数据库（由我们的客户端） - XYZ.fdb

我已经在IB Expert中注册了这个XYZ.fdb数据库。
$ b

我能够成功运行一些视图和存储过程。但对于其他视图或存储过程，我得到以下错误：

无法格式化消息13：896 - 消息文件C：Windows \firebird.msg不是发现;
无效请求BLR，抵消623;函数LTRIM没有定义;模块名称或入口点无法找到;错误，解析过程XXXXXXX（stored_procedure名称）;

错误消息：

在地址00DCA0E5 'IBExpert.exe'。阅读地址00000000。

上周工作正常，我试图重新启动系统，反复安装Firebird和IB专家;我得到了一些存储过程和视图的上述错误，但其他视图和存储过程正常工作。

因为我上周没有这个问题，我之间重新安装了Firebird和IB Expert几次，我认为它有一些配置或注册问题。

你能否提供一步一步的方法来解决这个问题问题 - 这样我可以使用IB Expert访问Firebird数据库中的所有数据库对象？ 解决方案

由此产生的错误可能是由从IBExpert访问冲突，但原因肯定是缺少的UDF库，例如名为 rfunc.dll 或 freeadhocudf.dll的.dll文件或任何它被称为。

要找到缺少的.dll的名称，请单击IBExpert数据库注册中的UDF文件夹，检查数据库中使用的UDF。

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 ?

解决方案

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.

这篇关于IBExpert中的Firebird在访问某些存储过程时抛出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！