I am completely new to Firebird Database; I am working on a database *Firebird 2.5* that already exists; I retrieve the stored procedures and views (database objects) from this database to develop reports in Microsoft SSRS. I use Windows 7 Operating System.
Occasionally (not always) I get the following error when I run some stored procedures or views (database objects) that use the LTRIM function: ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- can't format message 13:896 - message file C:Windows\firebird.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) ; ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (I get this both in IB Expert and SSRS) This said I am able to access other database objects that do *not* use LTRIM function!! *My temporary workaround:* Sometimes I restart the machine, and am able to run these same stored procedures and views that threw this error sometime back. At other times, I restart the machine a couple of times, and am able to access these views and stored procedures. At some other times, I restart the machine many times, still not able to run the database objects. I get frustrated and quit for the day. When I open the machine fresh the next morning, I am able to run these objects again !! *What could be the reason for this ? And what will be the permanent solution ?* As I said earlier, this database is given by my client, and am *not* supposed to modify anything (such as changing LTRIM to something else) Any suggestion will be greatly appreciated.
