[#CORE-2841] Access to UDF / BLOB module "fbudf" is denied by server administrator error on embed

Firebird Core

Access to UDF / BLOB module "fbudf" is denied by server administrator error on embed

Created: 02/Feb/10 08:22 AM Updated: 09/Mar/10 07:29 AM

Component/s:

API / Client Library

Affects Version/s:

2.5 RC1

Fix Version/s:

None

Environment:

c#, .net 2.0 runtime, Windows XP, Firebird-2.5.0.25784-1_Win32_embed_RC1, FirebirdClient-2.5.1-NET20 ADO.NET Data Provider

Description

« Hide

On the client machine already run an application with interbase 6.0 ( firebird 1.0 ). Unfortunately my application database in firebird 2.0. So I must deploy with embed firebird client with .NET "One Click" technology. But the SRIGHT UDF function doesn't work on client machine.

"Access to UDF library "fbudf" is denied by server administrator." - was the error.

After I config firebird.conf UdfAccess I got another error messages:
"sright function unknow " or " not defined " - can't remember exactly

I don't know why, In my environment works everithing OK !

Do you know the solutinon ?

All

Comments

Change History

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Mark Rotteveel added a comment - 02/Feb/10 08:53 AM

The Firebird Tracker is intended for bugs in Firebird, not for support questions such as yours. Please direct your question to the Firebird-support list (see http://www.firebirdsql.org/index.php?op=lists for information)

[ Permalink | « Hide ]

Gábor Török added a comment - 07/Mar/10 11:50 AM

I wrote a longer comment, but the tracker refused to add it.
In short: this is a bug. Firebird embedded server accepts only absolute paths for UDF directory. I'm using FB 2.1.3 on WinXP SP3, and the bug came up using isql tool with my database creation script.

[ Permalink | « Hide ]

Gábor Török added a comment - 07/Mar/10 05:07 PM

I tested some variations and this issue happens only when I do not use the default root directory. But when I change the root directory, relative UDF paths are not referenced to location of fbembed.dll neither to the new root directory.

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 09/Mar/10 07:29 AM

Gábor Török ,

Original ticket is against Firebird 2.5 while you talking about 2.1.
In 2.5 root directory of embedded server is fbemed.dll directory.
In 2.1 root directory of embedded server is directory where .exe is located.
It is not clear what do you mean "I change the root directory"

Anyway, this is support question, use Firebird-support lis for it