Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create my own VFP 9.0 ole db provider DLL
- Thread starter northrd
- Start date
Regardless of whether its possible, WHY could you be bothered?
Regarding your stated problem, I would say that its likely permissions, or connection parameters which are preventing you from doing updates or deletes.
"I'm living so far beyond my income that we may almost be said to be living apart
Regarding your stated problem, I would say that its likely permissions, or connection parameters which are preventing you from doing updates or deletes.
"I'm living so far beyond my income that we may almost be said to be living apart
- Thread starter
- #3
Permissions ... hmmmmm
select * from openquery([fred], 'Update drugnote set dntnote="test1" where dntcode="ANPE1"')
works fine but returns (not suprisingly) error 7357 which aborts the procedure.
changing this to
update fred...drugnote set dntnote='test1' where dntcode='ANPE1'
returns
Msg 7333, Level 16, State 2, Line 1
Cannot fetch a row using a bookmark from OLE DB provider "VFPOLEDB" for linked server "fred".
So, between a rock and hard place.
select * from openquery([fred], 'Update drugnote set dntnote="test1" where dntcode="ANPE1"')
works fine but returns (not suprisingly) error 7357 which aborts the procedure.
changing this to
update fred...drugnote set dntnote='test1' where dntcode='ANPE1'
returns
Msg 7333, Level 16, State 2, Line 1
Cannot fetch a row using a bookmark from OLE DB provider "VFPOLEDB" for linked server "fred".
So, between a rock and hard place.
- Status
Similar threads
- Locked
- Question