Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\text.23.05.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>Using a Connection String</title> <link rel="StyleSheet" href="css/text.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="text.23.01.html#110002">18 The Text Driver</a> : Using a Connection String</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="110002">Using a Connection String</a></div> <div class="Body"><a name="161672">If you want to use a connection string for connecting to a database, or if your application </a>requires it, you must specify either a DSN (data source name), a File DSN, or a DSN-less connection in the string. The difference is whether you use the DSN=, FILEDSN=, or the DRIVER= keyword in the connection string, as described in the ODBC specification. A DSN or FILEDSN connection string tells the driver where to find the default connection information. Optionally, you may specify <span class="Emphasis">attribute=value</span> pairs in the connection string to override the default values stored in the data source.</div> <div class="Body"><a name="161673">The DSN connection string has the form:</a></div> <div class="syntax_first"><a name="161674">DSN=</a><span class="EquationVariables">data_source_name</span>[;<span class="EquationVariables">attribute=value</span>[;<span class="EquationVariables">attribute=value</span>]...]</div> <div class="Body"><a name="161675">The FILEDSN connection string has the form:</a></div> <div class="syntax_first"><a name="161676">FILEDSN=</a><span class="EquationVariables">filename.</span><span class="Syntax">dsn</span>[;<span class="EquationVariables">attribute=value</span>[;<span class="EquationVariables">attribute=value</span>]...]</div> <div class="Body"><a name="161677">The DSN-less connection string specifies a driver instead of a data source. All connection </a>information must be entered in the connection string because the information is not stored in a data source.</div> <div class="Body"><a name="161678">The DSN-less connection string has the form:</a></div> <div class="syntax_first"><a name="161679">DRIVER=[{]</a><span class="EquationVariables">driver_name</span>[}][;<span class="EquationVariables">attribute=value</span>[;<span class="EquationVariables">attribute=value</span>]...]</div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.06.html#110440', '');" name="161738">Table 18-2</a></span> lists the long and short names for each attribute, as well as the initial default value when the driver is first installed. You can specify either long or short names in the connection string.</div> <div class="Body"><a name="143666">An example of a DSN connection string with overriding attribute values for Text is:</a></div> <div class="syntax_first"><a name="109127">DSN=Text1;DB=C:\TEXTDATA;TT=Comma</a></div> <div class="Body"><a name="109128">A FILEDSN connection string is similar except for the initial keyword:</a></div> <div class="syntax_first"><a name="109129">FILEDSN=Text1.dsn;DB=C:\TEXTDATA;TT=Comma</a></div> <div class="Body"><a name="109130">A DSN-less connection string must provide all necessary connection information:</a></div> <div class="syntax_first"><a name="109131">DRIVER=DataDirect 7.0 TextFile (*.*);DB=C:\TEXTDATA;TT=Comma</a></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