My web service application updates a backend FoxPro database via the ole db driver. A partcular table I am updating invokes an "insert" trigger. I get the error message "Trigger failed in Location", Location being the name of the table. The trigger mechanism has been tested locally within the FoxPro development environemnt and works. A debug trace has been added to the trigger but indicates that the trigger waasn't called via the Ole Db driver.

Would anyone have any pointers as to why on insert the trigger isn't triggered.#

Many thanks