Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement