Trigger Issue
-
Hi Guru's I have a Linked Server in SQL 2005 to an Access 2003 database. I have written a stored procedure to insert a record into the Access DB. When I run the Proc on it's own, it perfoms the task, but the moment I call it from a Insert Trigger, do I get an Error Message Saying that the Linked Server does not support the required interface. Could someone please help me with a solution as to how I am going to insert / update the table in Access from SQL? Your help will be greatly appreciated. Kind Regards, Elizma
-
Hi Guru's I have a Linked Server in SQL 2005 to an Access 2003 database. I have written a stored procedure to insert a record into the Access DB. When I run the Proc on it's own, it perfoms the task, but the moment I call it from a Insert Trigger, do I get an Error Message Saying that the Linked Server does not support the required interface. Could someone please help me with a solution as to how I am going to insert / update the table in Access from SQL? Your help will be greatly appreciated. Kind Regards, Elizma
It seems likely that linked servers do not support triggers (spit - I hate triggers) so I would do the following. Do some reading on linked server/triggers (you mey get a definitive answer here). Move the insert to Access out of the trigger and into the proc that inserts into your SQL table. You will miss any inserts that do not go through the proc but is will work. If you have data inserting from another source then track it down and nail it.
Never underestimate the power of human stupidity RAH