> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...>
> wrote:
>>>>> Then connecting using IBX I delete the database trigger and I
> can once
>>>>> again connect via OBObjects
>>>>>
>>>>> But should I get this error sinse the database trigger is INACTIVE?
>>>> Perhaps the trigger already existed as ACTIVE and the RECREATE
> TRIGGER
>>>> statement didn't get committed?
>>>
>>> No - just tried it from scratch on a different DB using the above
>>> approach.
>> Activating / deactivating a database trigger works fine here. So my
>> guess is still, that the INACTIVE isn't visible to others and as IBO
>> might start a read-only transaction for query metadata, you get this
>> error. IBX probably does not start a read-only transaction at all, thus
>> no error.
>
>
> I use a DB with no Database trigges.
> I create a table.
> I create a database trigger as INACTIVE.
> I disconnect.
> I cant connect anymore using IBO.
>
>
> Whether or not the INACTIVE part is visible to others - I dont know.
> Whether IBO then starts a read-only transaction somewhere - I dont
> know. But when the trigger is INACTIVE it should not have any
> influence. Should it?

Right. An inactive trigger should not fire. But your error message
explicitly mentions the database trigger, so ...

I recall another problem with a Firebird 2.1 and a similar error
message, although this was with a read-only database in general when
connecting, though there was no database trigger involved.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/