Re: Distributed transactions
From: Gert E.R. Drapers (GertD_at_Online.SQLDev.Net)
Date: 08/15/03
- Next message: Jasper Smith: "Re: Deny 'sa' from accessing a datanase"
- Previous message: Gary Lam: "SQL server failed to call Excel's library after ms03-026 patch applied"
- In reply to: Noel: "Re: Distributed transactions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 14 Aug 2003 23:48:42 -0700
With Oracle 9i, Oracle wants you to use the Oracle Services for MTS in
Oracle9i, instead of the old MTXOCI solution that was used by the MSDAORA
provider.
http://otn.oracle.com/tech/windows/ora_mts/htdocs/oramtsfov9i.html
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:048401c362c2$4d081a60$a601280a@phx.gbl...
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
>
>
>.
>
- Next message: Jasper Smith: "Re: Deny 'sa' from accessing a datanase"
- Previous message: Gary Lam: "SQL server failed to call Excel's library after ms03-026 patch applied"
- In reply to: Noel: "Re: Distributed transactions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
