Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OpenRowSet problem
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
OpenRowSet problem
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01321821
Message ID:
01321821
Views:
112
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
Next
Reply
Map
View

Click here to load this message in the networking platform