Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\sqlservms.18.04.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>Connection Option Descriptions</title> <link rel="StyleSheet" href="css/sqlservms.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="sqlservms.18.01.html#179687">14 The SQL Server Legacy Wire Protocol Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="179687">Connection Option Descriptions</a></div> <div class="Body"><a name="179688">The following connection option descriptions are listed alphabetically by the GUI name that </a>appears on the driver Setup dialog. The connection string attribute name is listed immediately underneath the GUI name. For example:</div> <div class="hanging_label_head"><a name="179689">Application Using Threads</a></div> <div class="gutter_text_right"><a name="179690">Attribute</a></div> <div class="Body"><a name="179692">ApplicationUsingThreads (AUT)</a></div> <div class="Body"><a name="179693">In most cases, the GUI name and the attribute name are the same; however, some </a>exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.</div> <div class="Body"><a name="179694">Also, a few connection string attributes, for example, Password, do not have equivalent </a>options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.</div> <div class="Body"><a name="179695">NOTE: SQL Server driver connection string attributes do not use short name equivalents.</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#166089', '');" name="145808">Table 14-1</a></span> lists the connection string attributes supported by the SQL Server Legacy Wire Protocol driver on Windows.</div> <div class="head_2"><a name="211965">Windows</a></div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 14-1. <span style="color: #000000; font-size: 10.0pt; font-style: italic; font-variant: normal; font-weight: bold; text-transform: none; vertical-align: baseline;"><a name="166089">SQL Server Legacy Wire Protocol Attribute Names on Windows</a></span><span style="color: #000000; font-size: 10.0pt; font-style: italic; font-variant: normal; font-weight: bold; text-transform: none; vertical-align: baseline;"> </span><span style="color: #000000; font-size: 10.0pt; font-style: italic; font-variant: normal; font-weight: bold; text-transform: none; vertical-align: baseline;"> </span></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="154251">Attribute</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="154253">Default</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#111387', '');" name="154502">AnsiNPW</a></span> </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="154504">yes (Enabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109118', '');" name="154495">APP</a></span> </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="154497">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212022', '');" name="154485">AttachDBFileName</a></span></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="154490">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212049', '');" name="154478">AutoTranslate</a></span> </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="154480">yes (Enabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#108238', '');" name="154509">DATABASE</a></span> </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="154511">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#150115', '');" name="154516">DataSourceName (DSN)</a></span></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="154518">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#148581', '');" name="154553">Description (n/a)</a></span></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="154555">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#155867', '');" name="155259">FetchTSWTZasTimestamp (FTSWTZAT)</a></span> </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="155261">0 (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#155331', '');" name="156014">FetchTWFSasTime (FTWFSAT)</a></span> </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="156016">0 (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109899', '');" name="154543">LANGUAGE</a></span></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="154548">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212151', '');" name="154533">Network</a></span> </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="154538">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#114203', '');" name="154522">PWD (use Password for odbc.ini file)</a></span> </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="154528">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212203', '');" name="154560">QueryLog_On</a></span> </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="154562">no (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212179', '');" name="154567">QueryLogFile</a></span> </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="154569">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212246', '');" name="154662">QueryLogTime</a></span> </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="154667">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109421', '');" name="154652">QuotedID</a></span> </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="154657">no (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212275', '');" name="154642">Regional</a></span> </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="154647">yes (Enabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212315', '');" name="154632">SAVEFILE</a></span> </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="154637">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#174281', '');" name="154625">SERVER</a></span></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="154627">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#110112', '');" name="154618">SnapshotSerializable</a></span> </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="154620">0 (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212415', '');" name="154611">StatsLog_On</a></span> </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="154613">no (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212388', '');" name="154601">StatsLogFile</a></span> </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="154606">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#212455', '');" name="154594">Trusted_Connection</a></span> </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="154596">no (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109249', '');" name="154584">UID (use LogonID for odbc.ini file)</a></span> </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="154589">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#110199', '');" name="154574">WSID</a></span> </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="154579">None</a></div> </td> </tr> </table> <div class="head_2"><a name="211979">UNIX and Linux</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#144080', '');" name="144265">Table 14-2</a></span>. lists the connection string attributes supported by the SQL Server Legacy Wire Protocol driver on UNIX/Linux.</div> <div class="Body"><a name="145869">NOTE: SQL Server driver connection string attributes do not use short name equivalents.</a></div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 14-2. <a name="144080">SQL Server Legacy Wire Protocol Attribute Names on</a> UNIX/Linux </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="144084">Attribute</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="144086">Default</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#151315', '');" name="181323">Address</a></span> </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="181325">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#110272', '');" name="181316">AlternateServers</a></span> </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="181318">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#111387', '');" name="181309">AnsiNPW</a></span> </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="181311">yes (Enabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109118', '');" name="181302">APP</a></span> </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="181304">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#110516', '');" name="181295">ConnectionRetryCount</a></span> </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="181297">0</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#110868', '');" name="181288">ConnectionRetryDelay</a></span> </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="181290">3</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#150115', '');" name="181330">DataSourceName (DSN)</a></span> </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="181332">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#108238', '');" name="181337">DATABASE</a></span> </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="181339">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#148581', '');" name="181414">Description (n/a)</a></span> </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="181416">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#155867', '');" name="181407">FetchTSWTZasTimestamp (FTSWTZAT)</a></span> </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="181409">0 (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#155331', '');" name="181400">FetchTWFSasTime (FTWFSAT)</a></span> </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="181402">0 (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109743', '');" name="181393">IANAAppCodePage</a></span> </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="181395">4 (ISO 8559-1 Latin-1)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109899', '');" name="181386">LANGUAGE</a></span> </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="181388">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#150411', '');" name="181379">LoadBalancing (LB)</a></span> </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="181381">0 (Disabled</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#114203', '');" name="181372">PWD (use Password for odbc.ini file)</a></span> </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="181374">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109421', '');" name="181365">QuotedID</a></span> </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="181367">no (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#110112', '');" name="181358">SnapshotSerializable</a></span> </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="181360">0 (Disabled)</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#109249', '');" name="181351">UID (use LogonID for odbc.ini file)</a></span> </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="181353">None</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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.04.html#110199', '');" name="181344">WSID</a></span> </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="181346">None</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="110485">Alternate Servers</a></div> <div class="gutter_text_right"><a name="110486">Attribute</a></div> <div class="Body_attr"><a name="110272">AlternateServers</a></div> <div class="gutter_text_right"><a name="110273">Description</a></div> <div class="Body"><a name="218418">A list of alternate database servers to which the driver tries to connect if the primary </a>database server is unavailable. Specifying a value for this option enables connection failover for the driver. The value you specify must be in the form of a string that defines the physical location of each alternate server. All of the other required connection information for each alternate server is the same as what is defined for the primary server connection.</div> <div class="gutter_text_right"><a name="144966">Valid Values</a></div> <div class="syntax_first"><a name="144967">(Address=</a><span class="EquationVariables">addressvalue</span>[, . . .])</div> <div class="Body"><a name="170746">You must specify the network address of each alternate server.</a></div> <div class="Body"><a name="218232">NOTE: An alternate server address in IPv6 format must be enclosed in double quotation </a>marks.</div> <div class="gutter_text_right"><a name="170751">Example</a></div> <div class="Body"><a name="170752">The following two Alternate Servers values define two alternate database servers for </a>connection failover:</div> <div class="syntax_first"><a name="110353">AlternateServers=(Address=MySQLServer\Instance1,</a></div> <div class="syntax"><a name="110354">Address="255.125.1.11, 5002")</a></div> <div class="Body"><a name="186306">In this example, the network address of the last alternate contains commas. In this case, </a>enclose the network address with double quotation marks as shown.</div> <div class="gutter_text_right"><a name="110278">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="110279">None</a></div> <div class="gutter_text_right"><a name="110435">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#201690', '');" name="110440">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="111385">AnsiNPW</a></div> <div class="gutter_text_right"><a name="111386">Attribute</a></div> <div class="Body_attr"><a name="111387">AnsiNPW</a></div> <div class="gutter_text_right"><a name="111568">Description</a></div> <div class="Body"><a name="112019">Determines whether ANSI-defined behaviors are exposed.</a></div> <div class="gutter_text_right"><a name="111573">Valid Values</a></div> <div class="Body"><a name="111574">yes | no</a></div> <div class="Body"><a name="145799">When set to yes (Enabled), the driver uses ANSI-defined behaviors for handling NULL </a>comparisons, character data padding, warnings, and NULL concatenation. If the driver appears to be truncating trailing blank spaces, this attribute should be set to no.</div> <div class="Body"><a name="145800">When set to no (Disabled), ANSI-defined behaviors are not exposed.</a></div> <div class="gutter_text_right"><a name="111395">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="170613">yes (Enabled)</a></div> <div class="gutter_text_right"><a name="212003">GUI Tab</a></div> <div class="Body"><a name="212004">n/a</a></div> <div class="head_2_no_TOC"><a name="170618">Application Name</a></div> <div class="gutter_text_right"><a name="170619">Attribute</a></div> <div class="Body_attr"><a name="109118">APP</a></div> <div class="gutter_text_right"><a name="109119">Description</a></div> <div class="Body"><a name="218422">The name Microsoft SQL Server uses to identify your application.</a></div> <div class="gutter_text_right"><a name="109125">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="218426">string</a></span></div> <div class="Body"><a name="218427">where </a><span class="EquationVariables">string</span> is your application name.</div> <div class="gutter_text_right"><a name="109128">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="109129">None</a></div> <div class="gutter_text_right"><a name="109130">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="109135">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="212019">AttachDBFileName</a></div> <div class="gutter_text_right"><a name="212020">Attribute</a></div> <div class="Body_attr"><a name="212022">AttachDBFileName</a></div> <div class="gutter_text_right"><a name="212023">Description</a></div> <div class="Body"><a name="212024">The name of the primary file of an attachable database.</a></div> <div class="gutter_text_right"><a name="212025">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="212026">string</a></span> </div> <div class="Body"><a name="212027">where </a><span class="EquationVariables">string</span> is name of the primary file of an attachable database.</div> <div class="Body"><a name="212028">Include the full path and escape any slash ( \ ) characters if using a C character string </a>variable:</div> <div class="Body"><span class="Syntax"><a name="212029">AttachDBFileName=C:\\MyFolder\\MyDB.mdf</a></span> </div> <div class="Body"><a name="212030">This database is attached and becomes the default database for the connection. To use </a>AttachDBFileName, you must also specify the database name in either the SQLDriverConnnect DATABASE parameter or the SQL_COPT_CURRENT_CATALOG connection attribute. If the database was previously attached, Microsoft SQL Server will not reattach it; it will use the attached database as the default for the connection.</div> <div class="gutter_text_right"><a name="212031">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212033">None</a></div> <div class="gutter_text_right"><a name="212034">GUI Tab</a></div> <div class="Body"><a name="212035">n/a</a></div> <div class="head_2_no_TOC"><a name="212046">AutoTranslate</a></div> <div class="gutter_text_right"><a name="212047">Attribute</a></div> <div class="Body_attr"><a name="212049">AutoTranslate</a></div> <div class="gutter_text_right"><a name="212050">Description</a></div> <div class="Body"><a name="212051">Determines how ANSI character strings are translated. </a></div> <div class="gutter_text_right"><a name="212052">Valid Values</a></div> <div class="Body"><a name="212053">yes | no</a></div> <div class="Body"><a name="212059">If set to yes</a> (Enabled), ANSI character strings sent between the client and server are translated by converting through Unicode to minimize problems in matching extended characters between the code pages on the client and the server.</div> <div class="Body"><a name="212060">These conversions are performed on the client by the SQL Server Legacy Wire Protocol </a>driver. This requires that the same ANSI code page (ACP) used on the server be available on the client.</div> <div class="Body"><a name="212061">These settings have no effect on the conversions that occur for the following transfers:</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="212062">Unicode SQL_C_WCHAR client data sent to char, varchar, or text on the server.</a></div> </td> </tr> </table> </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="212063">Char, varchar, or text server data sent to a Unicode SQL_C_WCHAR variable on the </a>client.</div> </td> </tr> </table> </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="212064">ANSI SQL_C_CHAR client data sent to Unicode nchar, nvarchar, or ntext on the server.</a></div> </td> </tr> </table> </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="212065">Unicode char, varchar, or text server data sent to an ANSI SQL_C_CHAR variable on </a>the client.</div> </td> </tr> </table> </div> <div class="Body"><a name="212071">If set to no</a> (Disabled), character translation is not performed.</div> <div class="Body"><a name="212072">The SQL Server Legacy Wire Protocol driver does not translate client ANSI character </a>SQL_C_CHAR data sent to char, varchar, or text variables, parameters, or columns on the server. No translation is performed on char, varchar, or text data sent from the server to SQL_C_CHAR variables on the client. If the client and Microsoft SQL Server are using different ACPs, then extended characters can be misinterpreted.</div> <div class="gutter_text_right"><a name="212073">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212080">yes</a> (Enabled)</div> <div class="gutter_text_right"><a name="212081">GUI Tab</a></div> <div class="Body"><a name="212082">n/a</a></div> <div class="head_2_no_TOC"><a name="110514">Connection Retry Count</a></div> <div class="gutter_text_right"><a name="110515">Attribute</a></div> <div class="Body_attr"><a name="110516">ConnectionRetryCount</a></div> <div class="gutter_text_right"><a name="148117">Description</a></div> <div class="Body"><a name="165872">The number of times the driver retries connection attempts to the primary database server, </a>and if specified, alternate servers until a successful connection is established. </div> <div class="Body"><a name="148118">The Connection Retry Delay option specifies the wait interval, in seconds, to occur between </a>retry attempts. </div> <div class="gutter_text_right"><a name="148120">Valid Values</a></div> <div class="Body"><a name="148123">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="148124">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="148125">If set to 0, the driver does not try to connect after the initial unsuccessful attempt.</a></div> <div class="Body"><a name="148126">If set to </a><span class="EquationVariables">x</span>, the driver retries connection attempts the specified number of times. If a connection is not established during the retry attempts, the driver returns an error that is generated by the last server to which it tried to connect.</div> <div class="gutter_text_right"><a name="110530">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="110531">0</a></div> <div class="gutter_text_right"><a name="110532">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#201690', '');" name="110537">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="110866">Connection Retry Delay</a></div> <div class="gutter_text_right"><a name="110867">Attribute</a></div> <div class="Body_attr"><a name="110868">ConnectionRetryDelay</a></div> <div class="gutter_text_right"><a name="110869">Description</a></div> <div class="Body"><a name="148176">The number of seconds the driver waits between connection retry attempts when </a>Connection Retry Count is set to a positive integer. </div> <div class="gutter_text_right"><a name="148178">Valid Values</a></div> <div class="Body"><a name="148181">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="148182">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="148183">If set to 0, there is no delay between retries.</a></div> <div class="Body"><a name="148184">If set to </a><span class="EquationVariables">x</span>, the driver waits between connection retry attempts the specified number of seconds.</div> <div class="gutter_text_right"><a name="110880">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="110881">3</a></div> <div class="gutter_text_right"><a name="110882">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#201690', '');" name="110887">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="108580">Data Source Name</a></div> <div class="gutter_text_right"><a name="150113">Attribute</a></div> <div class="Body_attr"><a name="150115">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="150116">Description</a></div> <div class="Body"><a name="218431">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="179744">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="218435">string</a></span> </div> <div class="Body"><a name="218436">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="150127">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="150129">None</a></div> <div class="gutter_text_right"><a name="108596">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#130197', '');" name="108601">General tab</a></span></div> <div class="head_2_no_TOC"><a name="108235">Database Name</a></div> <div class="gutter_text_right"><a name="108236">Attribute</a></div> <div class="Body_attr"><a name="108238">DATABASE</a></div> <div class="gutter_text_right"><a name="108336">Description</a></div> <div class="Body"><a name="218440">The name of the database to which you want to connect.</a></div> <div class="gutter_text_right"><a name="179762">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="218444">database_name</a></span> </div> <div class="Body"><a name="218445">where </a><span class="EquationVariables">database_name</span> is the name of a valid database.</div> <div class="gutter_text_right"><a name="108387">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="108388">None</a></div> <div class="gutter_text_right"><a name="108389">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#130197', '');" name="108394">General tab</a></span></div> <div class="head_2_no_TOC"><a name="109247">Default User Name</a></div> <div class="gutter_text_right"><a name="109248">Attribute</a></div> <div class="Body_attr"><a name="109249">UID (use LogonID for odbc.ini file)</a></div> <div class="gutter_text_right"><a name="109250">Description</a></div> <div class="Body"><a name="109302">The default user ID used to connect to your database. Your ODBC application may override </a>this value or you may override it in the logon dialog box or connection string.</div> <div class="gutter_text_right"><a name="148497">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="148538">userid</a></span></div> <div class="Body"><a name="148539">where </a><span class="EquationVariables">userid</span> is a valid user ID with permissions to access the database.</div> <div class="gutter_text_right"><a name="148500">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="109256">None</a></div> <div class="gutter_text_right"><a name="109257">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="109262">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="148578">Description</a></div> <div class="gutter_text_right"><a name="148579">Attribute</a></div> <div class="Body_attr"><a name="148581">Description (n/a)</a></div> <div class="gutter_text_right"><a name="148582">Description</a></div> <div class="Body"><a name="218449">An optional long description of a data source. This description is not used as a runtime </a>connection attribute, but does appear in the ODBC.INI section of the Registry and in the odbc.ini file.</div> <div class="gutter_text_right"><a name="179778">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="218453">string</a></span> </div> <div class="Body"><a name="218454">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="148593">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="148594">None</a></div> <div class="gutter_text_right"><a name="148595">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#130197', '');" name="148600">General tab</a></span></div> <div class="head_2_no_TOC"><a name="109419">Enable Quoted Identifiers</a></div> <div class="gutter_text_right"><a name="109420">Attribute</a></div> <div class="Body_attr"><a name="109421">QuotedID</a></div> <div class="gutter_text_right"><a name="148857">Description</a></div> <div class="Body"><a name="149794">Determines whether the driver allows the use of quoted identifiers.</a></div> <div class="gutter_text_right"><a name="148862">Valid Values</a></div> <div class="Body"><a name="148863">yes | no</a></div> <div class="Body"><a name="149900">If set to yes (Enabled), Microsoft SQL Server enforces ANSI rules regarding quotation </a>marks. Double quotation marks can only be used for identifiers, such as column and table names. Character strings must be enclosed in single quotation marks, for example:</div> <div class="syntax_first"><a name="150049">SELECT "au_id"</a></div> <div class="syntax"><a name="150050">FROM "authors"</a></div> <div class="syntax"><a name="150051">WHERE "au_lname" = 'O''Brien'</a></div> <div class="Body"><a name="150052">If set to no (Disabled), applications that use quoted identifiers encounter errors when they </a>generate SQL statements with quoted identifiers.</div> <div class="gutter_text_right"><a name="109430">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="109431">no (Disabled)</a></div> <div class="gutter_text_right"><a name="109432">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="109805">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="155864">Fetch TSWTZ as Timestamp</a></div> <div class="gutter_text_right"><a name="155865">Attribute</a></div> <div class="Body_attr"><a name="155867">FetchTSWTZasTimestamp (FTSWTZAT)</a></div> <div class="gutter_text_right"><a name="155868">Description</a></div> <div class="Body"><a name="218458">Determines whether the driver returns column values with the timestamp with time zone </a>data type as the ODBC data type SQL_TYPE_TIMESTAMP or SQL_VARCHAR.</div> <div class="gutter_text_right"><a name="179792">Valid Values</a></div> <div class="Body"><a name="218462">0 | 1</a></div> <div class="Body"><a name="218463">If set to 1 (Enabled), the driver returns column values with the timestamp with time zone </a>data type as the ODBC type SQL_TYPE_TIMESTAMP. The time zone information in the fetched value is truncated. Use this value if your application needs to process values the same way as TIMESTAMP columns.</div> <div class="Body"><a name="218464">If set to 0 (Disabled), the driver returns column values with the timestamp with time zone </a>data type as the ODBC data type SQL_VARCHAR. Use this value if your application requires the time zone information in the fetched value.</div> <div class="gutter_text_right"><a name="155880">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="155882">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="155974">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="155979">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="155328">Fetch TWFS as Time</a></div> <div class="gutter_text_right"><a name="155329">Attribute</a></div> <div class="Body_attr"><a name="155331">FetchTWFSasTime (FTWFSAT)</a></div> <div class="gutter_text_right"><a name="162772">Description</a></div> <div class="Body"><a name="218244">Determines whether the driver returns column values with the time data type as the ODBC </a>data type SQL_TYPE_TIME or SQL_TYPE_TIMESTAMP.</div> <div class="Body"><a name="162774">Supported only for Microsoft SQL Server 2008.</a></div> <div class="gutter_text_right"><a name="162775">Valid Values</a></div> <div class="Body"><a name="218248">0 | 1</a></div> <div class="Body"><a name="218249">If set to 1 (Enabled), the driver returns column values with the time data type as the ODBC </a>data type SQL_TYPE_TIME. The fractional seconds portion of the value is truncated.</div> <div class="Body"><a name="218250">If set to 0 (Disabled), the driver returns column values with the time data type as the ODBC </a>data type SQL_TYPE_TIMESTAMP. The fractional seconds portion of the value is preserved. Time columns are not searchable when they are described and fetched as timestamp</div> <div class="Body"><a name="218251">NOTE: When returning time with fractional seconds data as SQL_TYPE_TIMESTAMP, the </a>Year, Month and Day parts of the timestamp must be set to zero.</div> <div class="gutter_text_right"><a name="159565">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="159567">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="159568">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="155166">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="109806">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="109807">Attribute</a></div> <div class="Body_attr"><a name="109743">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="148636">Description</a></div> <div class="Body"><a name="218268">An Internet Assigned Numbers Authority (IANA) value. You must specify a value for this </a>option if your application is not Unicodeâ??enabled or if your database character set is not Unicode. Refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'unicode.06.1.html#106144', '');">Chapter 4 â??Internationalization, Localization, and Unicodeâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span> for details. </div> <div class="Body"><a name="218276">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="218277">The driver and Driver Manager both check for the value of IANAAppCodePage in the </a>following order:</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="218278">In the connection string</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="218279">In the Data Source section of the system information file (odbc.ini)</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="218280">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="218281">If the driver does not find an IANAAppCodePage value, the driver uses the default value of </a>4 (ISO 8859-1 Latin-1).</div> <div class="gutter_text_right"><a name="148655">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="218285">IANA_code_page</a></span> </div> <div class="Body"><a name="218287">where </a><span class="EquationVariables">IANA_code_page</span> is one of the valid values listed in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'appcodepage.03.1.html#108909', '');">Chapter 1 â??Values for the Attribute IANAAppCodePageâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span>. The value must match the database character encoding and the system locale.</div> <div class="gutter_text_right"><a name="148666">Default</a></div> <div class="Body"><a name="148668">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="148669">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="148674">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="109897">Language</a></div> <div class="gutter_text_right"><a name="109898">Attribute</a></div> <div class="Body_attr"><a name="109899">LANGUAGE</a></div> <div class="gutter_text_right"><a name="109900">Description</a></div> <div class="Body"><a name="218468">The national language to use for Microsoft SQL Server system messages.</a></div> <div class="gutter_text_right"><a name="179807">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="218472">lang</a></span></div> <div class="Body"><a name="218473">where </a><span class="EquationVariables">lang</span> is the language to use for Microsoft SQL Server system messages. This overrides the default language specified for the login on the server. If no language is specified, the connection uses the default language specified for the login on the server.</div> <div class="gutter_text_right"><a name="109908">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="109909">None</a></div> <div class="gutter_text_right"><a name="109910">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="109915">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="111187">Load Balancing</a></div> <div class="gutter_text_right"><a name="111188">Attribute</a></div> <div class="Body_attr"><a name="150411">LoadBalancing (LB)</a></div> <div class="gutter_text_right"><a name="150412">Description</a></div> <div class="Body"><a name="150415">Determines whether the driver uses client load balancing in its attempts to connect to the </a>database servers (primary and alternate). You can specify one or multiple alternate servers by setting the Alternate Servers option. </div> <div class="gutter_text_right"><a name="150417">Valid Values</a></div> <div class="Body"><a name="150420">0 | 1</a></div> <div class="Body"><a name="150421">If set to 1 (Enabled), the driver uses client load balancing and attempts to connect to the </a>database servers (primary and alternate servers) in random order. </div> <div class="Body"><a name="150422">If set to 0 (Disabled), the driver does not use client load balancing and connects to each </a>server based on their sequential order (primary server first, then, alternate servers in the order they are specified). </div> <div class="gutter_text_right"><a name="150424">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="150426">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="150427">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#201690', '');" name="150432">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="212148">Network</a></div> <div class="gutter_text_right"><a name="212149">Attribute</a></div> <div class="Body_attr"><a name="212151">Network</a></div> <div class="gutter_text_right"><a name="212152">Description</a></div> <div class="Body"><a name="212153">The name of a network library dynamic-link library.</a></div> <div class="gutter_text_right"><a name="212154">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="212155">string</a></span></div> <div class="Body"><a name="212156">where </a><span class="EquationVariables">string</span> is the name of a network library dynamic-link library. The name need not include the path and must not include the .DLL file name extension, for example, <span class="Syntax">Network=</span><span class="Syntax">dbnmpntw</span>.</div> <div class="gutter_text_right"><a name="212157">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212159">None</a></div> <div class="gutter_text_right"><a name="212160">GUI Tab</a></div> <div class="Body"><a name="212161">n/a</a></div> <div class="head_2_no_TOC"><a name="114200">PWD</a></div> <div class="gutter_text_right"><a name="114201">Attribute</a></div> <div class="Body_attr"><a name="114203">PWD (use Password for odbc.ini file)</a></div> <div class="gutter_text_right"><a name="114204">Description</a></div> <div class="Body"><a name="218477">The password that the application uses to connect to your database. The Password option </a>cannot be specified through the driver Setup dialog box and should not be stored in a data source. It is specified through the Logon dialog box or a connection string.</div> <div class="gutter_text_right"><a name="179865">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="218481">pwd</a></span> </div> <div class="Body"><a name="218482">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="Body"><a name="150648">PWD need not be specified if the login has a NULL password.</a></div> <div class="gutter_text_right"><a name="150649">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="150651">None</a></div> <div class="gutter_text_right"><a name="114214">GUI Tab</a></div> <div class="Body"><a name="114215">n/a</a></div> <div class="head_2_no_TOC"><a name="212176">QueryLogFile</a></div> <div class="gutter_text_right"><a name="212177">Attribute</a></div> <div class="Body_attr"><a name="212179">QueryLogFile</a></div> <div class="gutter_text_right"><a name="212180">Description</a></div> <div class="Body"><a name="212181">The full path and file name of a file to be used for logging data about long-running queries. </a>The QueryLog_On option must be set to yes.</div> <div class="gutter_text_right"><a name="212182">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="212183">string</a></span></div> <div class="Body"><a name="212184">where </a><span class="EquationVariables">string</span> is the full path and file name of the file to be used for logging data.</div> <div class="gutter_text_right"><a name="212185">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212187">None</a></div> <div class="gutter_text_right"><a name="212188">GUI Tab</a></div> <div class="Body"><a name="212189">n/a</a></div> <div class="head_2_no_TOC"><a name="212200">QueryLog_On</a></div> <div class="gutter_text_right"><a name="212201">Attribute</a></div> <div class="Body_attr"><a name="212203">QueryLog_On</a></div> <div class="gutter_text_right"><a name="212204">Description</a></div> <div class="Body"><a name="212205">Determines whether data about long-running queries data is logged.</a></div> <div class="gutter_text_right"><a name="212206">Valid Values</a></div> <div class="Body"><a name="212207">yes | no</a></div> <div class="Body"><a name="212213">When set to yes</a> (Enabled), logging data about long-running queries data is enabled on the connection.</div> <div class="Body"><a name="150857">When set to no</a> (Disabled), long-running query data is not logged.</div> <div class="gutter_text_right"><a name="212224">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212230">no</a> (Disabled)</div> <div class="gutter_text_right"><a name="212231">GUI Tab</a></div> <div class="Body"><a name="212232">n/a</a></div> <div class="head_2_no_TOC"><a name="212243">QueryLogTime</a></div> <div class="gutter_text_right"><a name="212244">Attribute</a></div> <div class="Body_attr"><a name="212246">QueryLogTime</a></div> <div class="gutter_text_right"><a name="212247">Description</a></div> <div class="Body"><a name="212248">A digit character string specifying the threshold for logging data about long-running queries.</a></div> <div class="gutter_text_right"><a name="212249">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="212250">string</a></span></div> <div class="Body"><a name="212251">where </a><span class="EquationVariables">string</span> is a digit character string specifying the threshold in milliseconds, for logging data.</div> <div class="Body"><a name="150992">Any query that does not receive a response in the time specified is written to the </a>long-running query log file.</div> <div class="gutter_text_right"><a name="212257">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212259">None</a></div> <div class="gutter_text_right"><a name="212260">GUI Tab</a></div> <div class="Body"><a name="212261">n/a</a></div> <div class="head_2_no_TOC"><a name="212272">Regional</a></div> <div class="gutter_text_right"><a name="212273">Attribute</a></div> <div class="Body_attr"><a name="212275">Regional</a></div> <div class="gutter_text_right"><a name="212276">Description</a></div> <div class="Body"><a name="212277">Determines how currency, date, and time data are converted.</a></div> <div class="gutter_text_right"><a name="212278">Valid Values</a></div> <div class="Body"><a name="212279">yes | no</a></div> <div class="Body"><a name="212285">When set to yes</a> (Enabled), the SQL Server Legacy Wire Protocol driver uses client settings when converting currency, date, and time data to character data. The conversion is one way only; the driver does not recognize non-ODBC standard formats for date strings or currency values.</div> <div class="Body"><a name="212291">When set to no</a> (Disabled), the driver uses ODBC standard strings to represent currency, date, and time data that is converted to string data.</div> <div class="gutter_text_right"><a name="212292">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212299">yes</a> (Enabled)</div> <div class="gutter_text_right"><a name="212300">GUI Tab</a></div> <div class="Body"><a name="212301">n/a</a></div> <div class="head_2_no_TOC"><a name="212312">SAVEFILE</a></div> <div class="gutter_text_right"><a name="212313">Attribute</a></div> <div class="Body_attr"><a name="212315">SAVEFILE</a></div> <div class="gutter_text_right"><a name="212316">Description</a></div> <div class="Body"><a name="212317">The name of an ODBC data source file into which the attributes of the current connection </a>are saved.</div> <div class="gutter_text_right"><a name="212318">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="212319">string</a></span></div> <div class="Body"><a name="212320">where </a><span class="EquationVariables">string</span> is the name of an ODBC data source file into which the attributes of the current connection are saved if the connection is successful.</div> <div class="gutter_text_right"><a name="212321">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212323">None</a></div> <div class="gutter_text_right"><a name="212324">GUI Tab</a></div> <div class="Body"><a name="212325">n/a</a></div> <div class="head_2_no_TOC"><a name="174278">Server</a></div> <div class="gutter_text_right"><a name="174279">Attribute</a></div> <div class="Body_attr"><a name="174281">SERVER</a></div> <div class="gutter_text_right"><a name="151313">Attribute</a></div> <div class="Body_attr"><a name="151315">Address</a></div> <div class="gutter_text_right"><a name="108869">Description</a></div> <div class="Body"><a name="108945">The location of the server.</a></div> <div class="gutter_text_right"><a name="181852">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="181853">IP_address </a></span>| <span class="EquationVariables">named_server</span> | <span class="EquationVariables">named_instance</span> | <span class="EquationVariables">server_name</span></div> <div class="Body"><a name="181854">where </a></div> <div class="Body"><span class="EquationVariables"><a name="171320">IP_address</a></span> is the IP address of the server to which you want to connect. Specify this address as: <span class="EquationVariables">IP_address</span>, <span class="EquationVariables">port_number</span>. For example, you can enter <span class="Syntax">199.226.224.34, 5000</span>.</div> <div class="Body"><a name="218236">The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two. </a>See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'usingproduct.05.05.html#107073', '');">â??Using IP Addressesâ??</a></span> for details about these formats.</div> <div class="Body"><span class="EquationVariables"><a name="181842">named_server</a></span> is the named server address of the server to which you want to connect. Specify this address as: <span class="EquationVariables">named_server</span>, <span class="EquationVariables">port_number</span>. For example, you can enter <span class="Syntax">SSserver, </span><span class="Syntax">5000</span>.</div> <div class="Body"><span class="EquationVariables"><a name="171329">named_instance</a></span> is a named instance of Microsoft SQL Server. Specify this address as: <span class="EquationVariables">server_name\instance_name</span>. If only a server name is specified with no instance name, the driver uses the default named instance on the server.</div> <div class="Body"><span class="EquationVariables"><a name="212370">server_name</a></span> is the name of a server on your network. It must be an entry on the Alias tab of the SQL Server Network Client Utility or the network name of a server running Microsoft SQL Server. You can enter <span class="Syntax">(local)</span> when the driver is on the same computer as the Microsoft SQL Server database. You can connect to a local copy of Microsoft SQL Server, even when it is a non-networked version. Microsoft SQL Server 2000 and higher support multiple instances of Microsoft SQL Server running on the same computer.</div> <div class="gutter_text_right"><a name="108877">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="108878">None</a></div> <div class="gutter_text_right"><a name="108879">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#130197', '');" name="115651">General tab</a></span></div> <div class="head_2_no_TOC"><a name="212385">StatsLogFile</a></div> <div class="gutter_text_right"><a name="212386">Attribute</a></div> <div class="Body_attr"><a name="212388">StatsLogFile</a></div> <div class="gutter_text_right"><a name="212389">Description</a></div> <div class="Body"><a name="212390">The full path and file name of a file to be used for recording SQL Server Legacy Wire </a>Protocol driver performance data. The StatsLog_On option must be set to yes.</div> <div class="gutter_text_right"><a name="212391">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="212392">string</a></span></div> <div class="Body"><a name="212393">where </a><span class="EquationVariables">string</span> is the full path and file name of the file to be used for recording data.</div> <div class="gutter_text_right"><a name="212394">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212396">None</a></div> <div class="gutter_text_right"><a name="212397">GUI Tab</a></div> <div class="Body"><a name="115799">n/a</a></div> <div class="head_2_no_TOC"><a name="212412">StatsLog_On</a></div> <div class="gutter_text_right"><a name="212413">Attribute</a></div> <div class="Body_attr"><a name="212415">StatsLog_On</a></div> <div class="gutter_text_right"><a name="212416">Description</a></div> <div class="Body"><a name="212417">Determines whether SQL Server Legacy Wire Protocol driver performance data is made </a>available.</div> <div class="gutter_text_right"><a name="212418">Valid Values</a></div> <div class="Body"><a name="212419">yes | no</a></div> <div class="Body"><a name="212425">When set to yes</a> (Enabled), SQL Server Legacy Wire Protocol driver performance data is captured. </div> <div class="Body"><a name="212431">When set to no</a> (Disabled), SQL Server Legacy Wire Protocol driver performance data is not available on the connection.</div> <div class="gutter_text_right"><a name="212432">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212439">no</a> (Disabled)</div> <div class="gutter_text_right"><a name="212440">GUI Tab</a></div> <div class="Body"><a name="212441">n/a</a></div> <div class="head_2_no_TOC"><a name="212452">Use NT Authentication</a></div> <div class="gutter_text_right"><a name="212453">Attribute</a></div> <div class="Body_attr"><a name="212455">Trusted_Connection</a></div> <div class="gutter_text_right"><a name="212456">Description</a></div> <div class="Body"><a name="212457">Specifies that the SQL Server Legacy Wire Protocol driver request a secure (or trusted) </a>connection to Microsoft SQL Server.</div> <div class="gutter_text_right"><a name="212458">Valid Values</a></div> <div class="Body"><a name="212459">0 | 1</a></div> <div class="Body"><a name="152918">When set to 1</a> (Enabled), Microsoft SQL Server uses integrated login security to establish connections using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored. The Microsoft SQL Server system administrator must have associated your Windows network ID with a Microsoft SQL Server login ID.</div> <div class="Body"><a name="212475">When set to 0</a> (Disabled), Microsoft SQL Server uses standard login security to establish connections using this data source. In this case, you must specify a login ID and password for all connection requests.</div> <div class="gutter_text_right"><a name="212476">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="212483">0</a> (Disabled)</div> <div class="gutter_text_right"><a name="212484">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="212489">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110110">Use Snapshot Transactions</a></div> <div class="gutter_text_right"><a name="110111">Attribute</a></div> <div class="Body_attr"><a name="110112">SnapshotSerializable</a></div> <div class="gutter_text_right"><a name="110113">Description</a></div> <div class="Body"><a name="218486">Allows your application to use the snapshot isolation level if your Microsoft SQL Server </a>database is configured for Snapshot isolation. Supported only for Microsoft SQL Server 2005 and higher.</div> <div class="Body"><a name="110174">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.09.html#186228', '');">â??Isolation and Lock Levels Supportedâ??</a></span> for details about using the snapshot isolation level.</div> <div class="Body"><a name="179875">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.05.html#108218', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="110118">Valid Values</a></div> <div class="Body"><a name="218490">0 | 1</a></div> <div class="Body"><a name="218491">When set to 1 (Enabled) and your application has the transaction isolation level set to </a>serializable, the application uses the snapshot isolation level.</div> <div class="Body"><a name="218492">When set to 0 (Disabled) and your application has the transaction isolation level set to </a>serializable, the application uses the serializable isolation level.</div> <div class="Body"><a name="218493">This option is useful for existing applications that set the isolation level to serializable. Using </a>Snapshot Transactions in this case allows you to change to the snapshot isolation level with no or minimum code changes. If developing a new application, you can code it to set the connection attribute SQL_COPT_SS_TXN_ISOLATION to the value SQL_TXN_SS_SNAPSHOT.</div> <div class="gutter_text_right"><a name="110120">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="110121">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="110122">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="110127">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110197">Workstation ID</a></div> <div class="gutter_text_right"><a name="110198">Attribute</a></div> <div class="Body_attr"><a name="110199">WSID</a></div> <div class="gutter_text_right"><a name="110200">Description</a></div> <div class="Body"><a name="218497">The workstation ID that is used by the client.</a></div> <div class="gutter_text_right"><a name="179906">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="218501">string</a></span></div> <div class="Body"><a name="218502">where </a><span class="EquationVariables">string</span> is the workstation ID.</div> <div class="gutter_text_right"><a name="110205">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="110206">None</a></div> <div class="gutter_text_right"><a name="110207">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlservms.18.03.html#119950', '');" name="110212">Advanced tab</a></span></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