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

问题描述

我对 Firebird 完全陌生；我得到了一个 Firebird 2.5 数据库(由我们的客户提供)- XYZ.fdb

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

我已经在 IB Expert 中注册了这个 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:

无法格式化消息 13:896 - 找不到消息文件 C:Windowsfirebird.msg；偏移量 623 处的无效请求 BLR；函数 LTRIM 未定义；找不到模块名称或入口点；解析过程 XXXXXXX (stored_procedure name) 时出错；

can't format message 13:896 - message file C:Windowsfirebird.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) ;

模块IBExpert.exe"中地址 00DCA0E5 处的访问冲突.读取地址 00000000.

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

上周运行良好；我试过重启系统，一遍遍安装Firebird和IB Expert；我收到了一些存储过程和视图的上述错误，但其他视图和存储过程工作正常.

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.

由于我上周没有遇到这个问题，并且在此期间我重新安装了 Firebird 和 IB Expert 几次，我认为它有一些配置或注册问题.

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.

您能否为我提供解决此问题的分步方法 - 以便我可以使用 IB Expert 访问 Firebird DB 中的所有数据库对象?

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 ?

推荐答案

产生的错误可能是由于来自 IBExpert 的访问冲突造成的，但原因肯定是缺少 UDF 库，例如名为 的 .dll 文件rfunc.dll 或 freeadhocudf.dll 或任何名称.

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.

要查找丢失的 .dll 的名称，请通过单击 IBExpert 数据库注册中的 UDF 文件夹检查数据库中使用的 UDF.

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屋！