Subject Determining the Root_Directory
Author Dan Cooperstock
I am starting Embedded Firebird from within PowerBuilder, and it is
not finding my UDFs.

I have tried putting a Firebird.conf file specifying the
Root_Directory (under which I have the UDFs in a UDF directory) in
both the directory in which the PowerBuilder executable lives, and
the directory where it starts (as set is its shortcut). Also in the
directory that the ODBC driver is in.

I have also tried setting the FIREBIRD environment variable. I also
have a Server installed, and a UDF directory under the directory that
is the DefaultInstance value of the
HKEY_LOCAL_MACHINE\SOFTWARE\Firebird Project\Firebird
Server\Instances registry key. (According the Firebird book, those
are the first two places it looks to determine the Root_Directory.)

None of this seems to work.

Is there a way that I can interrogate a running Firebird instance
(whether embedded or server) to ask what it thinks its Root_Directory
is? That would help me sort this out.

By the way, when I run my compiled PowerBuilder application (i.e. not
from within the PowerBuilder IDE), everything works as it should. The
UDF directory is under the application directory, there is no
firebird.conf file needed, and it finds the UDFs.

Thank you.