Professional Web Applications Themes

How to trace xid of X/open Transaction - Microsoft SQL / MS SQL Server

Hi , I am quite new in MS SQL and does not know about trace facility available with MS SQL SERVER. I am using MS SQL SERVER as resource manager which is in turn used by our transaction manager and I am using ODBC as programming language I had turned up connection attribute SQL_COPT_SS_ENLIST_IN_XA to true to get XA compilent transaction. but I am not able to sync commit issued by Transaction manager with MS SQL Server. so no transaction is able to commit . so I want to trace the same using SQL Server trace facility. Is anybody knows ...

  1. #1

    Default How to trace xid of X/open Transaction

    Hi ,
    I am quite new in MS SQL and does not know about trace facility available
    with MS SQL SERVER. I am using MS SQL SERVER as resource manager which is in
    turn used by our transaction manager and I am using ODBC as programming
    language I had turned up connection attribute SQL_COPT_SS_ENLIST_IN_XA to
    true to get XA compilent transaction. but I am not able to sync commit
    issued by Transaction manager with MS SQL Server. so no transaction is able
    to commit . so I want to trace the same using SQL Server trace facility.
    Is anybody knows how to activate and read the trace which can be generate
    the XId for a transaction so we can veryfy with our TRACE generated by
    transaction manager.
    Thanks in advance for help.

    - Sharad.


    sharad Guest

  2. #2

    Default Re: How to trace xid of X/open Transaction

    See if this helps...
    [url]http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20159&pg=1[/url]

    --
    -oj
    RAC v2.2 & QALite!
    [url]http://www.rac4sql.net[/url]



    "sharad" <sha_pawarhotmail.com> wrote in message
    news:beliv4$gb0$1news.btv.ibm.com...
    > Hi ,
    > I am quite new in MS SQL and does not know about trace facility
    available
    > with MS SQL SERVER. I am using MS SQL SERVER as resource manager which is
    in
    > turn used by our transaction manager and I am using ODBC as programming
    > language I had turned up connection attribute SQL_COPT_SS_ENLIST_IN_XA to
    > true to get XA compilent transaction. but I am not able to sync commit
    > issued by Transaction manager with MS SQL Server. so no transaction is
    able
    > to commit . so I want to trace the same using SQL Server trace facility.
    > Is anybody knows how to activate and read the trace which can be
    generate
    > the XId for a transaction so we can veryfy with our TRACE generated by
    > transaction manager.
    > Thanks in advance for help.
    >
    > - Sharad.
    >
    >

    oj Guest

Similar Threads

  1. WS-Transaction
    By moko in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 13th, 12:25 AM
  2. Transaction Log
    By Shamim in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: August 22nd, 06:25 AM
  3. Transaction
    By basidati in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: August 8th, 03:41 PM
  4. Transaction id and transaction isolation
    By Alex in forum Informix
    Replies: 3
    Last Post: July 23rd, 09:33 PM
  5. How to do a trace
    By hedrew3 in forum Adobe Photoshop Elements
    Replies: 0
    Last Post: June 23rd, 06:09 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139