Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OpenRowSet problem
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
OpenRowSet problem
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01321821
Message ID:
01321821
Vues:
113
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 SP2, any ideas ?
Regards,
Peter J. Kane



Pete
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform