Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OpenRowSet problem
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
OpenRowSet problem
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01322058
Message ID:
01322058
Views:
60
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
Next
Reply
Map
View

Click here to load this message in the networking platform