Hi,

I am looking at using FB embedded for a local application, however, I keep running into a problem with UDF and stored procedures. This is using a DB created with IB Console, using Delphi 5 and IBX to access the database.

The application can log into the database just fine, retrieve data withstored procedures, etc. All without problems. However when I apply a procedure stored in the database that uses a UDF I get the error message:

"Invalid request the function XXX not defined. Module name or entry point could not be found."

This database and application runs fine using Interbase 6.1 CS, so there is nothing wrong with the external functions stored in the database (and all my trials were done with IB server turned off).

Folder tree for my application using FB embedded is:

c:\programme\test demo\app.exe
c:\programme\test demo\gds32.dll
c:\programme\test demo\firebird.conf
c:\programme\test demo\firebird.msg
c:\programme\test demo\udf\ib_udf.dll

I have tried every combination of default settings and folder setting for RootDirectory and UdfAccess that I can think of. Even trying "test_demo" for the folder in case there was an issue with spaces in the folder name. I tried the ib_udf.dll supplied by interbase and the one supplied by the FB Embedded download. Rebuilt the external functions in the database when I changed the DLL. I even added another folder level as in the readme file to:

c:\programme\test demo\app.exe
c:\programme\test demo\gds32.dll
c:\programme\test demo\firebird.conf
c:\programme\test demo\fb\firebird.msg
c:\programme\test demo\fb\udf\ib_udf.dll

And tried again every combination of default settings and folder setting for RootDirectory and UdfAccess. All to no effect. The error continues. Most settings do not even report an error in the error log. So I assume there is no error in my folder assignments and firebird.conf file.

This can not be that hard... what is going on? I did see several older posts that this was an issue back in 2001, but nothing recent. I also saw a post this was a problem on Windows 9.x systems. Any help would be appreciated.

Thanks,

Kevin