December 7, 2004 at 8:15 pm
I keep getting the following error when trying to execute a trigger which updates a linked server.
The requested operation could not be performed because the OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not support the required transaction interface.
Anyone out there have any ideas on what could be cause?
Cheers,
Shane
December 10, 2004 at 8:00 am
This was removed by the editor as SPAM
December 13, 2004 at 8:25 am
Perhaps "Jet.OLEDB.4.0". This is an Access driver, not a SQL Server driver. Your linked server will need to be recreated to use a SQL driver.
Chris
December 13, 2004 at 3:42 pm
I'm afraid it won't work. SQL Server ensures transactional integrity with triggers, and I don't think there's any way to modify that behavior. Since Access does not support these kinds of transactions...
You can get around the problem by having your trigger enter rows into a holding table and then scheduling a process to update Access based on the holding table data every minute or so.
But be warned: Linking to Access databases is *not* a good idea. I've been warned by Microsoft against doing precisely that as it can corrupt the Access file. I've seen it happen.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply