Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\sybase.16.10.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>MTS Support</title> <link rel="StyleSheet" href="css/sybase.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="sybase.16.01.html#107724">12 The Sybase Wire Protocol Driver</a> : MTS Support</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="107724">MTS Support</a></div> <div class="Body"><a name="352403">On Windows, the driver can take advantage of Microsoft Transaction Server (MTS) </a>capabilities, specifically, the Distributed Transaction Coordinator (DTC) using the XA Protocol. For a general discussion of MTS and DTC, refer to the help file of the Microsoft Transaction Server SDK.</div> <div class="Body"><a name="352404">NOTE: The DataDirect Connect </a><span class="forbody">for</span> <span class="APIbody">ODBC</span> 32-bit drivers can operate in a 64-bit Windows environment; however, they do not support DTC in this environment. Only the DataDirect Connect64 <span class="forbody">for</span> <span class="APIbody">ODBC</span> 64-bit drivers support DTC in a 64-bit Windows environment.</div> <div class="Body"><a name="107733">To enable DTC support, you must be accessing Sybase Adaptive Server Enterprise 12.0 or </a>higher. You can choose either Native OLE and XA protocol distributed transactions. See the Distributed Transaction Model option documented in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sybase.16.03.html#106234', '');">â??Configuring and Connecting to Data Sourcesâ??</a></span> for details.</div> <div class="hanging_label_head"><a name="107737">To enable distributed transaction in the Sybase server:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="107738">Assign the dtm_tm_role to each user who will participate in distributed transactions </a>(who will log in to Adaptive Server). You can do this using the sp_role command. For example:</div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="107739">sp_role "grant", dtm_tm_role, </a><span class="EquationVariables">user_name</span></div> <div class="Body_Indent"><a name="107740">In the open string for resource managers, the specified username must have the </a>dtm_tm_role.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="107741">Specify a default database other than the master for each user. Sybase cannot start </a>distributed transactions in a master database.</div> </td> </tr> </table> </div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de