Linked server to oracle update error

From: Pardha (pardha.kolachina_at_wipro.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 02:31:43 -0700

We are having a linked server to Oracle 7.x from SQL 2000

When I try to update a column from a C# program, I
encountered the following error.

Could not execute query against OLE DB provider 'MSDAORA'.
OLE DB error trace [OLE/DB Provider 'MSDAORA'
ICommandText::Execute returned 0x8007007e].

Update openquery(STMLink,'select * from Tg_Transit WHERE
DOC_NO="ABO0095S" AND Variant_Code="JCCE976KAP90" AND
FACTORY_ORDER_REF = "BANRP434MTR"") set Updation_Flag='Y'
Trace: at System.Data.OleDb.OleDbDataReader.NextResults
(IMultipleResults imultipleResults, OleDbConnection
connection, OleDbCommand command)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal
(CommandBehavior behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at
STMPuller.Class_STMData.updateSTMData(String StrDocno,
Boolean IsCfa)

Select statement is working on the same linked server and
update is working from SQL client.

Relevant Pages

  • RE: 0x80004005 - you need permission to view its data
    ... When creating the Access linked server, make sure the data source using UNC ... the SQL server(Both SQL authentication and Windows Authentication work). ... 262177 How to enable Kerberos event logging ...
    (microsoft.public.sqlserver.security)
  • Linked Servers - Real Post
    ... I am running SQL 2k on Win 2k. ... a front end for our SQL database. ... added the linked server I want, and SQL queries it fine, ... leaving the "local server login to remote server login" ...
    (microsoft.public.sqlserver.programming)
  • Linked Server - Issue
    ... I have to access a Linked Server S2 (SQL 2000). ... In S1 I have setup a linked server using sp_addlinkedserver pointing to S2. ... Both MyAccount and SpecialAccount has access permissions to S2. ... Reason Not associated with a Trusted SQL ...
    (microsoft.public.sqlserver.programming)
  • OLE DB provider MSIDXS reported an error. Access denied.
    ... I've added a linked server to a development box. ... I ran the same command on my local Sql box. ... OLE DB error trace [OLE/DB Provider 'MSIDXS' ICommandPrepare::Prepare ... The development sql instance is running under a local system account. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Transfering only updated data (from as400 to SQL2000)
    ... Rifat, ... Create a linked server of the AS400. ... > will identify rows that require moving at ETL time. ... >> as400 to SQL. ...
    (microsoft.public.sqlserver.dts)