Delete via linked server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sanjay (Sanjay_at_discussions.microsoft.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 11:23:04 -0700

I am trying to delete records in a table pointing via linked server to Sybase
IQ
The login used in Linked server has all rights to do this
I can select using this linked server

I am gettng this msg, pls help

Server: Msg 7345, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' could not delete from table '"dbo"."all_metric"'.
User did not have sufficient permission to delete the row.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated
errors. Check each OLE DB status value, if available. No work was done.]
[OLE/DB provider returned message: [Sybase][ODBC Driver][Adaptive Server
IQ]Option value out of range: Update operation attempted on a read-only
cursor]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::DeleteRows
returned 0x80040e21: DBROWSTATUS_E_PERMISSIONDENIED].

Relevant Pages

  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)
  • connecting to two adp projects error-
    ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ... The operation could not be performed because the OLE DB provider 'SQLOLEDB' ...
    (microsoft.public.access.adp.sqlserver)
  • Active Directory as linked Server in SQL
    ... I have learnt that this can be done using linked server. ... OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare returned 0x80040e14]. ...
    (microsoft.public.sqlserver.server)
  • Connection problem between SQL 2000 and SYBASE
    ... The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. ... OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. ...
    (microsoft.public.sqlserver.server)
  • RE: OLE DB to Active Directory from SQL 2000
    ... OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare returned 0x80040e14]. ...
    (microsoft.public.data.oledb)