DTC on server is unavailable ..?

DTC on server is unavailable ..?

Post by ali nasi » Tue, 23 Oct 2001 21:54:57

Dear all,

I established a linked server for my servers using ODBC, The host is SQL
Server 2K run at Windows 2K Advance Server and The Remote Machine is SQL 6.5
run at Windows NT. And DTC service is run on Both Server.

I  run this script below on my server , but it can't work.

( bat,iseq,bu,fln,alcon,custkey,nam,des,add_
exec INF4..._sp_LOG_Extract_s_01 'A173712B58','A100'

The result is :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'MSDASQL'
was unable to begin a distributed transaction.
[OLE/DB provider returned message: [Microsoft][ODBC SQL Server Driver][SQL
Server]DTC on server '' is unavailable]

but if i execute "exec INF4..._sp_LOG_Extract_s_01 'A173712B58','A100' " in
single statement,
the result :
NULL 2414271 mts0697   A173712B58 NULL Bank Rakyat Indonesia PT Persero NULL
Jl Cut Mutiah 22 10340 Bp Feri     2301073   A100 B S 3 D NULL NULL NULL
B1145A B DISK 2000-11-22 00:00:00.000 RLT ILD 1998-12-14 00:00:00.000   0

 it works and give me a result set. I want to insert the result set to
table, and i want to use it as a source table for another process.

would you please help me , what should i suppose to do to fix that error ..?

best regards,

Ali Nasir
Application Support Group Coordinator
Infra Structure Information Technology Department
Tel : +62 21 7201221
Fax : +62 21 7201226

URL : www.infomedia.web.id

Unless otherwise indicated, this email and any attachments hereto contain
information, which is confidential and/or protected by intellectual property
rights, and are intended for the sole use of the recipient(s) named above
under the terms of confidentiality and non-use agreements. Any use of the
information contained herein (including but not limited to total or partial
reproduction, communication or distribution in any form) by persons other
than the designated recipient(s) or for purposes not permitted by such
agreements, is prohibited. If you have received this email in error, please
notify the sender either by telephone or by e-mail and delete the material
from any computer. Thank you for your cooperation.


1. DTC on server 'MYSERVER' is unavailable

While trying to check MSDTC installation:

I am running the following SQL statement: "BEGIN DISTRIBUTED TRANSACTION"
(using SQL Enterprise Manager).

The following error message appears:
"Msg 8501, Level 16, State 1
DTC on server 'MYSERVER' is unavailable"

I am using WinNT4/SP3 Wkst with MSSQL6.5/SP4 installed as standalone.

(The workstation is not networked; used only for development and testing)

Please help me!!!!!!!


2. SQL Backtrack

3. DTC is unavailable.

4. Career Change

5. DTC unavailable

6. Q: Embedded SQL for C. Low-level calls?

7. MS DTC is unavailable

8. Windows Explorer

9. MSDTC on server is unavailable linked server

10. Does SQL 7 DTC work with MTS 2.0 DTC

11. directing DTC trace to DTC console ?

12. DTC: which one is valid DTC?

13. SQL 6.5 server is unavailable