Hi All,

My VB 6 application is connected to and Informix Dynamic Server Database using Adodc1 via an ODBC DSN. My problem is that when I run a query to disable a trigger on a table it comes back with 2 errors..

(Error 1) - Operation is not allowed when object is closed
(Error 2) - Run-time Error '3704': Application-defined or Object-defined Error

I have no problem performing any other queries on the same database

Below are my connection to tyhe database as well as my queries


Adodc1.ConnectionString = "Provider=MSDASQL.1;Password=;Persist Security Info=True;User ID=auth;Data Source=authtest;Initial Catalog=Authority"

Adodc1.RecordSource = "SET TRIGGERS URAUTH_TO_NAR DISABLED"
Adodc1.Refresh

The above errors occur on the refresh of adodc1

Any insight or answers for why this is occuring would be great

Regards
Anthony