General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL 7.0 and Distributed queries
I've created a linked server in sql server using the MDASQL provider with the Microsoft Visual Foxpro odbc driver. Using this linked server I'm able to run queries and update tables from an sql script and within the ISQL query tool just fine. When I insert a similar update statement into a trigger I get the response:
OLE/DB provider returned message: [Microsoft Visual Foxpro Driver] Driver not capable.
This is some of the trigger code:
CREATE Trigger tr_CustomerChange
On mstcm
For Update
As
if Update(cm_acct)
begin
update openquery([SBT_AR],'select custno from arcust01')
set custno = inserted.cm_acct
from inserted,deleted
where custno = deleted.cm_acct
end
I'm wondering if this has to do with the join on the deleted table. Any one have any idea's?
Jeff
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only