Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OpenRowSet problem
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
OpenRowSet problem
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01322058
Message ID:
01322058
Vues:
61
Apols for double posting - under pressure :-)

Hi All, I need to update some Fox tables from SQL Server 2000, here's what I've tried without success
update openrowset
('vfpoledb.1','\\pjkserver\data\apps\app1\data';'';'','Select active from mytable where pkref = "E10295"') 
Set active = 0
I receive the error
Server: Msg 7301, Level 16, State 2, Line 1
Could not obtain a required interface from OLE DB provider 'vfpoledb.1'.
OLE DB error trace [OLE/DB Provider 'vfpoledb.1' IRowsetChange::QueryInterface returned 0x80004002:  IRowsetChange].
If I just execute the Select part it works fine - I have the latest VFPOleDB driver and am running XP pro Service Pack 2, any ideas ?
Regards,
Peter J. Kane



Pete
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform