Subject Re: [IBO] ISC Error while running procedure
Author Helen Borrie
At 09:33 PM 19/04/2004 +0000, you wrote:
>Here is the error code message
>
>ISC ERROR CODE:335544831
>
>ISC ERROR MESSAGE:
>subsystem name

This is what you should see for this error code:

335544831 conf_access_denied

Access to <string> "<string>" is denied by server administrator


>Now we have three clients using this specific system. Two of them
>are not getting this error. The one that is is running Firebird on
>linux.

Two things suggest themselves here (both, actually)

1. The wrong firebird.msg file is being read. Check version numbers at
both client and server
and
2. An SP is trying to access something that the server isn't configured to
allow; or that the user has no Linux privileges for.

There could be several reasons for 2), depending on what the *proper* error
message tells you.

>Mainly, my question is does anyone know what why this error code is
>generated? Since I have never seen this error before, I was curious
>if this was a specific linux error or not.

No, it's to do with configuration (most likely) or OS file permissions


>We are getting this error when one of our stored procedures is run.

What does the SP do? does it write out to an external file? Call a UDF?

>Any other info you might need to help me figure this one out, I will
>try to get. But I really did not know where to start with this one.

I've got probably the only current list of Error Codes and Messages for
Firebird 1.5 in existence - I got it from querying msg.fdb itself. It's an
Appendix in "The Firebird Book". I'm thinking I could put a version of it
up into the Contributed area...but the correct firebird.msg file should
give you the correct message and provide the appropriate clue to what's
causing the problem.

Helen