Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MSDTC service not available

20 views
Skip to first unread message

Royce Lithgo

unread,
Aug 11, 2003, 5:17:09 AM8/11/03
to
I've setup a Linked Server to an Oracle DB and have
created a view in MS SQL Server to fetch data from the
Oracle DB. The following SQL issues an Error:

BEGIN TRANSACTION

insert into PS_JRNL_HEADER
select * from PS_JRNL_HEADER_ARC_VW

Server: Msg 7391, Level 16, State 1, Line 3
The operation could not be performed because the OLE DB
provider 'MSDAORA' was unable to begin a distributed
transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA'
ITransactionJoin::JoinTransaction returned 0x8004d01b].

If I Run the same SQL from a DTS Package with workflow
properties set to join transaction if available, I get a
different error:

The Microsoft Distributed Transaction Coordinator (MSDTC
service) is not available.

The MSDTC service is running on the server.

Any ideas?

Dinesh.T.K

unread,
Aug 11, 2003, 10:56:05 AM8/11/03
to
Royce,

The error is discussed here:

HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280106


--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"Royce Lithgo" <Royce....@sg.standardchartered.com> wrote in message
news:05bf01c35fe9$57302ea0$a101...@phx.gbl...

Royce Lithgo

unread,
Aug 11, 2003, 10:24:38 PM8/11/03
to
I have verified everything in that article and it's still
not working. Looks like Distributed Transactions aren't
going to work for us.

>.
>

Gert E.R. Drapers

unread,
Aug 12, 2003, 12:06:36 AM8/12/03
to
Which OS is this on?
Which Oracle version are you connecting to? Are you using Oracle MTS or are
you using MTXOCI ?

Ge...@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.

"Royce Lithgo" <Royce....@sg.standardchartered.com> wrote in message

news:002601c36078$e0f9b8b0$a001...@phx.gbl...

odilon

unread,
Oct 20, 2003, 1:43:16 PM10/20/03
to

I solved a problem like that, thru some registry keys changes......

my environment

Windows Server 2000 - COM + - Oracle Client 9 e Oracle Trans.
Services 9

AIX - Oracle server

Registry keys before to change:

HKLM\SOFTWARE\Microsoft\MSDTC\MTxOCI

OracleOciLib REG_SZ ociw32.dll

OracleSqlLib REG_SZ SQLLib18.dll

OracleXaLib REG_SZ xa73.dll

Registry keys correcting the problem:

HKLM\SOFTWARE\Microsoft\MSDTC\MTxOCI

OracleOciLib REG_SZ oci.dll

OracleSqlLib REG_SZ ORASQL9.dll

OracleXaLib REG_SZ oraclient9.dll

I hope this solution is able to be apllied to you


--
odilonOCS


Posted via http://dbforums.com

0 new messages