Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    1

    Question Unanswered: About distributed trans

    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?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •