Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m_mussu
Starting Member
4 Posts |
 Posted - 2003-03-10 : 05:22:59
|
| Hello i am working with Linked Server asMSSQL Server and Mainframe(VSAM) file through HIS(host Integration Server) and sucessfully created and i amable to select the records from VSAM to SQL Server and can insert the records.The problem is for update when isubmit the Query ie.update hisvsam...[SYSP.Z2ZXZ.TEST.ARAB.VSAM] set [User Name]= 'z2mam test' where [User ID]= '00103'i am gettin this error:Server: Msg 7333, Level 16, State 2, Line 1Could not fetch a row using a bookmark from OLE DB provider 'SNAOLEDB'. [OLE/DB provider returned message: Record not found.]OLE DB error trace [OLE/DB Provider 'SNAOLEDB' IRowsetLocate::GetRowsByBookmark returned 0x80040e21: 303031303300].can any body help me .ThanksMAMMOhammed A.Musaddique |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-11 : 12:26:42
|
| I doubt that you are going to find the answer here. You will need to do some research on your OLE DB prodiver to determine what the error message means. But just by looking at it, I would suspect that it isn't finding any records to update. I don't know why it wouldn't just say 0 records found though.Tara |
 |
|
|
|
|
|
Linked Server error(SQL Server with VSAM using HIS