by 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.
TRUNCATE TABLE flatfile..BPT_IN
INSERT INTO flatfile..BPT_IN
( bat,iseq,bu,fln,alcon,custkey,nam,des,add_
,idty,pl,pabx,usg,dep,prime,outty,ch,upc,doc
,tgdoc,trcod,uid,lup,cad,cnt,tgkonfirm,flagdata
)
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
NULL
====
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
PT.INFOMEDIA NUSANTARA
Tel : +62 21 7201221
Fax : +62 21 7201226
URL : www.infomedia.web.id
**************Disclaimer*************************
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.