Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\unixenv.07.7.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>DSN-less Connections</title> <link rel="StyleSheet" href="css/unixenv.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="unixenv.07.1.html#107137">4 Configuring the Product on UNIX/Linux</a> : DSN-less Connections</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="107137">DSN-less Connections</a></div> <div class="Body"><a name="107138">Connections to a data source can be made via a connection string without referring to a </a>data source name (DSN-less connections). This is done by specifying the "DRIVER=" keyword instead of the "DSN=" keyword in a connection string, as outlined in the ODBC specification. A file named odbcinst.ini must exist when the driver encounters DRIVER= in a connection string.</div> <div class="Body"><a name="107139">Setup installs a default version of this file in the product installation directory (see </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.2.html#106242', '');">â??ODBCINSTâ??</a></span> for details about relocating and renaming this file). This is a plain text file that contains default DSN-less connection information. You should not normally need to edit this file. The content of this file is divided into several sections.</div> <div class="Body"><a name="107143">At the beginning of the file is a section named </a><span class="Syntax">[ODBC Drivers]</span> that lists installed drivers, for example,</div> <div class="syntax_first"><a name="107144">DataDirect Oracle Wire Protocol=Installed.</a></div> <div class="Body"><a name="107145">This section also includes additional information for each driver.</a></div> <div class="Body"><a name="107146">The next section of the file is named </a><span class="Syntax">[Administrator]</span>. The keyword in this section, <span class="Syntax">AdminHelpRootDirectory</span>, is required for the Linux ODBC Administrator to locate its help system. The installation process automatically provides the correct value for this keyword.</div> <div class="Body"><a name="107147">The final section of the file is named </a><span class="Syntax">[ODBC]</span>. The <span class="Syntax">[ODBC]</span> section in the odbcinst.ini file fulfills the same purpose in DSN-less connections as the <span class="Syntax">[ODBC]</span> section in the odbc.ini file does for data source connections. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106368', '');">â??Configuration Through the System Information (odbc.ini) Fileâ??</a></span> for a description of the other keywords this section.</div> <div class="Body"><a name="107151">NOTE: The odbcinst.ini file and the odbc.ini file include an </a><span class="Syntax">[ODBC]</span> section. If the information in these two sections is not the same, the values in the odbc.ini <span class="Syntax">[ODBC]</span> section override those of the odbcinst.ini <span class="Syntax">[ODBC]</span> section.</div> <div class="head_2_no_TOC"><a name="107153">Sample odbcinst.ini File</a></div> <div class="Body"><a name="107154">The following is a sample odbcinst.ini. All occurrences of ODBCHOME are replaced with </a>your installation directory path during installation of the file. Commented lines are denoted by the # symbol. This sample shows 32-bit drivers with file names beginning with iv; a 64-bit driver file would be identical except that driver names would begin with dd.</div> <div class="syntax_first"><a name="107155">[ODBC Drivers]</a></div> <div class="syntax"><a name="107156">DataDirect 7.0 DB2 Wire Protocol=Installed</a></div> <div class="syntax"><a name="143186">DataDirect 7.0 dBASEFile (*.dbf)=Installed</a></div> <div class="syntax"><a name="143187">DataDirect 7.0 Greenplum Wire Protocol=Installed</a></div> <div class="syntax"><a name="143188">DataDirect 7.0 Informix Wire Protocol=Installed</a></div> <div class="syntax"><a name="143189">DataDirect 7.0 MySQL Wire Protocol=Installed</a></div> <div class="syntax"><a name="107161">DataDirect 7.0 Oracle Wire Protocol=Installed</a></div> <div class="syntax"><a name="143194">DataDirect 7.0 PostgreSQL Wire Protocol=Installed</a></div> <div class="syntax"><a name="132275">DataDirect 7.0 Progress OpenEdge Wire Protocol=Installed</a></div> <div class="syntax"><a name="124021">DataDirect 7.0 SQL Server Wire Protocol=Installed</a></div> <div class="syntax"><a name="143199">DataDirect 7.0 Sybase Wire Protocol=Installed</a></div> <div class="syntax"><a name="128399">DataDirect 7.0 Salesforce=Installed</a></div> <div class="syntax"><a name="143204">DataDirect 7.0 Teradata=Installed</a></div> <div class="syntax"><a name="143205">DataDirect 7.0 TextFile (*.*)=Installed</a></div> <div class="syntax"><a name="143206">DataDirect 7.0 Informix=Installed</a></div> <div class="syntax"><a name="124894">DataDirect 7.0 Oracle=Installed</a></div> <div class="syntax"><a name="124900">DataDirect 7.0 SQL Server Legacy Wire Protocol=Installed</a></div> <div class="syntax"><a name="107170"> </a></div> <div class="syntax"><a name="107171">[DataDirect 7.0 DB2 Wire Protocol]</a></div> <div class="syntax"><a name="107172">Driver=ODBCHOME/lib/ivdb226.so</a></div> <div class="syntax"><a name="107173">APILevel=0</a></div> <div class="syntax"><a name="107174">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="107175">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="107176">FileUsage=0</a></div> <div class="syntax"><a name="107177">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="125391">Setup=ODBCHOME/lib/ivdb226.so</a></div> <div class="syntax"><a name="125392">SQLLevel=0</a></div> <div class="syntax"><a name="125393"> </a></div> <div class="syntax"><a name="107181">[DataDirect 7.0 dBASEFile (*.dbf)]</a></div> <div class="syntax"><a name="107182">Driver=ODBCHOME/lib/ivdbf26.so</a></div> <div class="syntax"><a name="107183">APILevel=0</a></div> <div class="syntax"><a name="107184">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="107185">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="107186">FileExtns=*.dbf</a></div> <div class="syntax"><a name="107187">FileUsage=1</a></div> <div class="syntax"><a name="107188">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="107189">Setup=ODBCHOME/lib/ivdbf26.so</a></div> <div class="syntax"><a name="107190">SQLLevel=0</a></div> <div class="syntax"><a name="143211"> </a></div> <div class="syntax"><a name="143212">[DataDirect 7.0 Greenplum Wire Protocol]</a></div> <div class="syntax"><a name="143213">Driver=ODBCHOME/lib/ivgplm26.so</a></div> <div class="syntax"><a name="143214">APILevel=0</a></div> <div class="syntax"><a name="143215">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143216">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143217">FileUsage=0</a></div> <div class="syntax"><a name="143218">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143219">Setup=ODBCHOME/lib/ivgplm26.so</a></div> <div class="syntax"><a name="143220">SQLLevel=0</a></div> <div class="syntax"><a name="143221"> </a></div> <div class="syntax"><a name="143222">[DataDirect 7.0 Informix Wire Protocol]</a></div> <div class="syntax"><a name="143223">Driver=ODBCHOME/lib/ivifcl26.so</a></div> <div class="syntax"><a name="143224">APILevel=0</a></div> <div class="syntax"><a name="143225">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143226">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143227">FileUsage=0</a></div> <div class="syntax"><a name="143228">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143229">Setup=ODBCHOME/lib/ivifcl26.so</a></div> <div class="syntax"><a name="143230">SQLLevel=0</a></div> <div class="syntax"><a name="143231"> </a></div> <div class="syntax"><a name="143232">[DataDirect 7.0 MySQL Wire Protocol]</a></div> <div class="syntax"><a name="143233">Driver=ODBCHOME/lib/ivmysql26.so</a></div> <div class="syntax"><a name="143234">APILevel=0</a></div> <div class="syntax"><a name="143235">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143236">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143237">FileUsage=0</a></div> <div class="syntax"><a name="143238">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143239">Setup=ODBCHOME/lib/ivmysql26.so</a></div> <div class="syntax"><a name="143240">SQLLevel=0</a></div> <div class="syntax"><a name="107220"> </a></div> <div class="syntax"><a name="107221">[DataDirect 7.0 Oracle Wire Protocol]</a></div> <div class="syntax"><a name="107222">Driver=ODBCHOME/lib/ivora26.so</a></div> <div class="syntax"><a name="107223">APILevel=0</a></div> <div class="syntax"><a name="107224">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="107225">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="107226">FileUsage=0</a></div> <div class="syntax"><a name="107227">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="107228">Setup=ODBCHOME/lib/ivora26.so</a></div> <div class="syntax"><a name="107229">SQLLevel=0</a></div> <div class="syntax"><a name="143245"> </a></div> <div class="syntax"><a name="143246">[DataDirect 7.0 PostgreSQL Wire Protocol]</a></div> <div class="syntax"><a name="143247">Driver=ODBCHOME/lib/ivpsql26.so</a></div> <div class="syntax"><a name="143248">APILevel=0</a></div> <div class="syntax"><a name="143249">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143250">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143251">FileUsage=0</a></div> <div class="syntax"><a name="143252">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143253">Setup=ODBCHOME/lib/ivpsql26.so</a></div> <div class="syntax"><a name="143254">SQLLevel=0</a></div> <div class="syntax"><a name="143255"> </a></div> <div class="syntax"><a name="132344">[DataDirect 7.0 Progress OpenEdge Wire Protocol]</a></div> <div class="syntax"><a name="132345">Driver=ODBCHOME/lib/ivoe26.so</a></div> <div class="syntax"><a name="132346">APILevel=1</a></div> <div class="syntax"><a name="132347">ConnectFunctions=YYN</a></div> <div class="syntax"><a name="132348">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="132349">SQLLevel=0</a></div> <div class="syntax"><a name="124096"> </a></div> <div class="syntax"><a name="132360">[DataDirect 7.0 SQL Server Wire Protocol]</a></div> <div class="syntax"><a name="124097">Driver=ODBCHOME/lib/ivsqls26.so</a></div> <div class="syntax"><a name="124098">APILevel=1</a></div> <div class="syntax"><a name="124099">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="124100">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="124101">FileUsage=0</a></div> <div class="syntax"><a name="124102">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="124104">SQLLevel=0</a></div> <div class="syntax"><a name="143260"> </a></div> <div class="syntax"><a name="143261">[DataDirect 7.0 Sybase Wire Protocol]</a></div> <div class="syntax"><a name="143262">Driver=ODBCHOME/lib/ivase26.so</a></div> <div class="syntax"><a name="143263">APILevel=0</a></div> <div class="syntax"><a name="143264">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143265">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143266">FileUsage=0</a></div> <div class="syntax"><a name="143267">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143268">Setup=ODBCHOME/lib/ivase26.so</a></div> <div class="syntax"><a name="143269">SQLLevel=0</a></div> <div class="syntax"><a name="143270"> </a></div> <div class="syntax"><a name="128407">[DataDirect 7.0 Salesforce]</a></div> <div class="syntax"><a name="128408">Driver=ODBCHOME/lib/ivsfrc26.so</a></div> <div class="syntax"><a name="128410">APILevel=0</a></div> <div class="syntax"><a name="128411">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="128412">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="128413">FileUsage=0</a></div> <div class="syntax"><a name="128414">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="128404">SQLLevel=0</a></div> <div class="syntax"><a name="128405"> </a></div> <div class="syntax"><a name="143275">[DataDirect 7.0 Sybase IQ Wire Protocol]</a></div> <div class="syntax"><a name="143276">Driver=ODBCHOME/lib/ivsyiq26.so</a></div> <div class="syntax"><a name="143277">APILevel=0</a></div> <div class="syntax"><a name="143278">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143279">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143280">FileUsage=0</a></div> <div class="syntax"><a name="143281">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143282">SQLLevel=0</a></div> <div class="syntax"><a name="143283"> </a></div> <div class="syntax"><a name="143284">[DataDirect 7.0 Teradata]</a></div> <div class="syntax"><a name="143285">Driver=ODBCHOME/lib/ivtera26.so</a></div> <div class="syntax"><a name="143286">APILevel=0</a></div> <div class="syntax"><a name="143287">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143288">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143289">FileUsage=0</a></div> <div class="syntax"><a name="143290">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143291">Setup=ODBCHOME/lib/ivtera26s.so</a></div> <div class="syntax"><a name="143292">SQLLevel=0</a></div> <div class="syntax"><a name="143293"> </a></div> <div class="syntax"><a name="143294">[DataDirect 7.0 TextFile (*.*)]</a></div> <div class="syntax"><a name="143295">Driver=ODBCHOME/lib/ivtxt26.so</a></div> <div class="syntax"><a name="143296">APILevel=0</a></div> <div class="syntax"><a name="143297">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143298">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143299">FileExtns=*.*</a></div> <div class="syntax"><a name="143300">FileUsage=1</a></div> <div class="syntax"><a name="143301">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143302">Setup=ODBCHOME/lib/ivtxt26.so</a></div> <div class="syntax"><a name="143303">SQLLevel=0</a></div> <div class="syntax"><a name="143304"> </a></div> <div class="syntax"><a name="143305">[DataDirect 7.0 Informix]</a></div> <div class="syntax"><a name="143306">Driver=ODBCHOME/lib/ivinf26.so</a></div> <div class="syntax"><a name="143307">APILevel=0</a></div> <div class="syntax"><a name="143308">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="143309">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="143310">FileUsage=0</a></div> <div class="syntax"><a name="143311">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="143312">SQLLevel=0</a></div> <div class="syntax"><a name="124926"> </a></div> <div class="syntax"><a name="124927">[DataDirect 7.0 Oracle]</a></div> <div class="syntax"><a name="124928">Driver=ODBCHOME/lib/ivor826.so</a></div> <div class="syntax"><a name="124929">APILevel=0</a></div> <div class="syntax"><a name="124930">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="124931">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="124932">FileUsage=0</a></div> <div class="syntax"><a name="124933">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="124934">Setup=ODBCHOME/lib/ivor826s.so</a></div> <div class="syntax"><a name="124935">SQLLevel=0</a></div> <div class="syntax"><a name="124944"> </a></div> <div class="syntax"><a name="124945">[DataDirect 7.0 SQL Server Legacy Wire Protocol]</a></div> <div class="syntax"><a name="124946">Driver=ODBCHOME/lib/ivmsss26.so</a></div> <div class="syntax"><a name="124947">APILevel=2</a></div> <div class="syntax"><a name="124948">ConnectFunctions=YYY</a></div> <div class="syntax"><a name="124949">DriverODBCVer=3.52</a></div> <div class="syntax"><a name="124950">FileUsage=0</a></div> <div class="syntax"><a name="124951">HelpRootDirectory=ODBCHOME/help</a></div> <div class="syntax"><a name="124952">Setup=ODBCHOME/lib/ivmsss26s.so</a></div> <div class="syntax"><a name="124953">SQLLevel=0</a></div> <div class="syntax"><a name="120678"> </a></div> <div class="syntax"><a name="120526">[Administrator]</a></div> <div class="syntax"><a name="120527">HelpRootDirectory=ODBCHOME/adminhelp</a></div> <div class="syntax"><a name="120710"> </a></div> <div class="syntax"><a name="107404">[ODBC]</a></div> <div class="syntax"><a name="107405">#This section must contain values for DSN-less connections</a></div> <div class="syntax"><a name="107406">#if no odbc.ini file exists. If an odbc.ini file exists,</a></div> <div class="syntax"><a name="107407">#the values from that [ODBC] section are used.</a></div> <div class="syntax"><a name="135778"> </a></div> <div class="syntax"><a name="135780">IANAAppCodePage=4</a></div> <div class="syntax"><a name="134429">InstallDir=ODBCHOME</a></div> <div class="syntax"><a name="134430">Trace=0</a></div> <div class="syntax"><a name="134431">TraceFile=odbctrace.out</a></div> <div class="syntax"><a name="134432">TraceDll=ODBCHOME/lib/odbctrac.so</a></div> <div class="syntax"><a name="134433">ODBCTraceMaxFileSize=102400</a></div> <div class="syntax"><a name="134434">ODBCTraceMaxNumFiles=10</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