Halo rekan2, Ada yang tahu error ini kenapa? Saya punya bbrp sql server 2000 yang masing2 terdiri dari bbrp database. Di masing2 server, saya daftarkan server lain dengan menggunakan Link Server. Saya coba buat satu stored procedure (SP) di salah satu server. Di SP ini saya coba untuk melakukan manipulasi data terhadap bbrp database yg berbeda server. Error muncul saat saya melakukan SELECT, UPDATE, INSERT atau DELETE.
Server: Msg 7391, Level 16, State 1, Procedure sp_DepositApprove, Line 72 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. Error muncul saat saya melakukan misalnya: SELECT * FROM Server1.Database1.dbo.Table1 Saya sertakan 1 contoh sederhana yg menghasilkan error berbeda: -------------------------------------------------------------------- CREATE PROCEDURE TestLinkSvr2 AS BEGIN DISTRIBUTED TRAN SELECT * FROM HAN2.Test2.dbo.Table1 IF @@ERROR <> 0 GOTO Gagal GOTO Sukses Gagal: ROLLBACK TRAN GOTO Keluar Sukses: COMMIT TRAN GOTO Keluar Keluar: SELECT 'Selesai' -------------------------------------------------------------------- Error: Server: Msg 7391, Level 16, State 1, Procedure TestLinkSvr2, Line 7 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ] Ada yg tahu kenapa error ini terjadi? ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
