Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\sqlserv.15.08.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>Advanced Features</title> <link rel="StyleSheet" href="css/sqlserv.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="sqlserv.15.01.html#225617">11 The SQL Server Wire Protocol Driver</a> : Advanced Features</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="225617">Advanced Features</a></div> <div class="Body"><a name="225618">The driver supports the following advanced features: </a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="225619">Failover</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="225620">Security</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="225621">Connection Pooling</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="225622">DataDirect Bulk Load</a></div> </td> </tr> </table> </div> <div class="head_2"><a name="225714">Failover</a></div> <div class="Body"><a name="225715">The driver supports failover and its related connection options. Failover connection options </a>are located on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.03.html#178639', '');">Failover tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.2.html#106175', '');">â??Using Failoverâ??</a></span> for a general description of failover and its implementation.</div> <div class="head_2"><a name="225750">Security</a></div> <div class="Body"><a name="225751">The driver supports authentication and encryption. Security connection options are located </a>on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.03.html#178559', '');">Security tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.4.html#118526', '');">â??Using Securityâ??</a></span> for a general description of security and its implementation. </div> <div class="head_3"><a name="225757">Authentication</a></div> <div class="Body"><a name="225758">If you are using Kerberos, verify that your environment meets the requirements listed in </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.08.html#225860', '');">Table 11-3</a></span> before you configure the driver for Kerberos authentication.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 11-3. <a name="225860">Kerberos Authentication Requirements for the SQL Server Wire Protocol Driver</a> </div> </caption> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="225864">Component</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="225866">Requirements</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="225868">Microsoft SQL Server </a>database server</div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="225870">The database server must be administered by the same domain controller that </a>administers the client and must be running one of the following databases:</div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="225871">Microsoft SQL Server 2008</a></div> </td> </tr> </table> </div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="225872">Microsoft SQL Server 2005</a></div> </td> </tr> </table> </div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="225873">Microsoft SQL Server 2000</a></div> </td> </tr> </table> </div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="225874">Microsoft SQL Server 2000 Enterprise Edition (64-bit) Service</a> Pack 2 or higher</div> </td> </tr> </table> </div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="225876">Kerberos server</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="225878">The Kerberos server is the machine where the user IDs for authentication are </a>administered. The Kerberos server is also the location of the Kerberos KDC. </div> <div class="table_text"><a name="225879">Network authentication must be provided by Windows Active Directory on one of </a>the following operating systems:</div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="225880">Windows Server 2003</a></div> </td> </tr> </table> </div> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="225881">Windows 2000 Server Service Pack 3 or higher</a></div> </td> </tr> </table> </div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="225883">Client</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="225885">The client must be administered by the same domain controller that administers the </a>database server.</div> </td> </tr> </table> <div class="head_2"><a name="237712">Connection Pooling</a></div> <div class="Body"><a name="225729">The driver supports connection pooling and its related connection options. Connection </a>pooling connection options are located on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.03.html#178712', '');">Pooling tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.5.html#113515', '');">â??Using DataDirect Connection Poolingâ??</a></span> for a general description of connection pooling and its implementation.</div> <div class="head_2"><a name="225898">DataDirect Bulk Load</a></div> <div class="Body"><a name="225899">The driver supports DataDirect bulk load and its related connection options. Bulk load </a>connection options are located on the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.03.html#178779', '');">Bulk tab</a></span> of the driver Setup dialog box. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.6.html#109749', '');">â??Using DataDirect Bulk Loadâ??</a></span> for a general description of DataDirect bulk load and its implementation.</div> <div class="Body"><a name="225926">For optimal performance, you must enable minimal logging and Table Locking. Please refer </a>to the following Web site for more information on minimal logging:</div> <div class="Body" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="http://msdn.microsoft.com/en-us/library/ms190422.aspx" target="external_window" name="225928">http://msdn.microsoft.com/en-us/library/ms190422.aspx</a></span></div> <div class="Body"><a name="225931">Table Locking, one of the Bulk Options, is enabled by default. This prevents other </a>transactions from accessing the table during bulk load. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.04.html#179684', '');">â??Bulk Optionsâ??</a></span> for details about this option.</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