I have two Server. One is Local, another is Remote. Both Installed SQL Server 2000 at Server 2000.
I start MSDTC on both the local and the remote. The Remote SQL Server start MTS.
When I run the code forward, the error message '7391' will occur
begin distributed tran
select * from rmtdb.pubs.dbo.employee --rmtdb is a linked server
go
How to verify the OLE DB provider specified supports distributed transactions?
How can I do for this error message?
How can I reconfig the Local Server and the Remote?Make sure you have these settings before SP or code :
SET ANSI_DEFAULTS ON
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET XACT_ABORT ON
No comments:
Post a Comment