Post reply

Error 7391

  • September 10, 2004 at 9:21 am

    #102195

    Hi everybody,

    I have a little problem with msdtc between two Windows 2003 server with Sql 2000 server, when I try to execute a query against a remote server I recive a 7391 error.

    I have configured Msdtc as specified in knowledge base of microsoft but it still doesn't work.

    My query use opendatasource statement and if I execute it without "begin transaction" and "commit transaction" it works correctly; when I execute it in a transaction I recive the error.

     

    Everyone as experienced this problem?

     

    Thanks

  • September 10, 2004 at 4:55 pm

    #522654

    It sounds like maybe you should be issuing BEGIN DISTRIBUTED TRANSACTION instead of BEGIN TRANSACTION.  You may also need to set other settings for distributed transactions, including SET XACT_ABORT ON.

    If that's not the problem ... well, 7391 can pop up for lots of reasons.  All of the 73xx series of messages are supposed to indicate problems with an OLEDB provider.  To see the full error message from the provider, you can run DBCC TRACEON (3604, 7300) and then execute your batch again.

    The following pages may be of interest to you also:  KB 306212 (http://support.microsoft.com/?kbid=306212) and (if XP SP2 is involved) KB 839279 (http://support.microsoft.com/?kbid=839279).  Another good article is at http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fen%2Fwc082702%2Fwct082702.asp.  If these don't help you, a search for "SQL Server" 7391 on Google(TM) will show you lots of other ideas. 

    Good luck!

    Chris

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply