Re: Distributed transactions

From: Noel (noelrquiroza_at_hotmail.com)
Date: 08/15/03 

Date: Thu, 14 Aug 2003 17:15:15 -0700

Thanks GertD, this the exact message

Server: Msg 7399, Level 16, State 1, Procedure
S_TRANSFERIR_BANCO_P, Line 82
OLE DB provider 'MSDAORA' reported an error. The provider
did not give any
information about the error.
OLE DB error trace [OLE/DB Provider 'MSDAORA'
ITransactionJoin::JoinTransaction returned 0x80004005:
The provider did not
give any information about the error.].

By the way I'm using both OLE DB Provider, Microsoft and
Oracle.

>-----Original Message-----
>This question is best asked in the .programming newsgroup.
>Anyhow which OLE DB provider are you using?
>Please post the exact error message including the HRESULT
>
>GertD@SQLDev.Net
>
>Please reply only to the newsgroups.
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk for your use.
>Copyright © SQLDev.Net 1991-2003 All rights reserved.
>
>"Noel" <noelrquiroza@hotmail.com> wrote in message
>news:065401c361ff$7b0b2ab0$a501280a@phx.gbl...
>> I'm trying to execute some modification of data true a
>> linked server to Oracle 9i from SQL Server 7.0, but I
>> received a message telling me that the OLEDB provider is
>> not supporting distributed transactions, I know that
maybe
>> somebody has done this, so if anyone can help me I would
>> really appreciate it.
>>
>> Thanks to all of you.
>>
>> Noel
>
>
>.
>

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)
  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.data.oledb)
  • RE: Samplclnt example in MDAC 2.8: My Story
    ... | OLE DB provider/consumer sample that is included in the MDAC 2.8 SDK. ... | what the consumer client uses to read the rudimentary .csv data file. ... | compiler errors. ... | sample OLE DB provider. ...
    (microsoft.public.data.oledb)
  • OLE DB error trace (OLE/DB Provider MSDAORA)
    ... OLE DB provider 'MSDAORA' ... Provider 'MSDAORA' IDBInitialize. ... I received the OLE/DB ...
    (microsoft.public.sqlserver.clustering)
  • RE: Database Lookup Functoid Connection String
    ... A OLE DB provider is a COM component which implement a number of COM ... And connection string is a way to initialize a OLE DB provider. ... accessed by the BizTalk server account, ...
    (microsoft.public.biztalk.general)