Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\unixenv.07.8.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>File Data Sources</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#114136">4 Configuring the Product on UNIX/Linux</a> : File Data Sources</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="114136">File Data Sources</a></div> <div class="Body"><a name="114137">The Driver Manager on UNIX and Linux supports file data sources. The advantage of a file </a>data source is that it can be stored on a server and accessed by other machines, either Windows, UNIX, or Linux. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'quikstart.04.1.html#106107', '');">â??Quick Start Connectâ??</a></span> for a general description of ODBC data sources on both Windows and UNIX.</div> <div class="Body"><a name="107420">A file data source is simply a text file that contains connection information. It can be created </a>through the Linux ODBC Administrator (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.4.html#106311', '');">â??Configuration Through the Administratorâ??</a></span>) or it can be created with a text editor. The file normally has an extension of .dsn.</div> <div class="Body"><a name="107424">For example, a file data source for the Oracle Wire Protocol driver would be similar to the </a>following:</div> <div class="syntax_first"><a name="107425">[ODBC]</a></div> <div class="syntax"><a name="107426">Driver=DataDirect Oracle Wire Protocol</a></div> <div class="syntax"><a name="107427">Port=1522</a></div> <div class="syntax"><a name="107428">HostName=ORA2</a></div> <div class="syntax"><a name="107429">LogonID=JOHN</a></div> <div class="syntax"><a name="107430">Servicename=SALES.US.ACME.COM</a></div> <div class="syntax"><a name="107431">CatalogOptions=1</a></div> <div class="Body"><a name="107432">It must contain all basic connection information plus any optional attributes. Because it uses </a>the "DRIVER=" keyword, an odbcinst.ini file containing the driver location must exist (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.7.html#107137', '');">â??DSN-less Connectionsâ??</a></span>).</div> <div class="Body"><a name="107436">The file data source is accessed by specifying the "FILEDSN=" instead of the "DSN=" </a>keyword in a connection string, as outlined in the ODBC specification. The complete path to the file data source can be specified in the syntax that is normal for the machine on which the file is located. For example, on Windows:</div> <div class="syntax_first"><a name="107437">FILEDSN=C:\Program Files\Common Files\ODBC\DataSources\Oraclewp.dsn</a></div> <div class="Body"><a name="107438">or, on UNIX and Linux:</a></div> <div class="syntax_first"><a name="107439">FILEDSN=/home/users/john/filedsn/Oraclewp2.dsn</a></div> <div class="Body"><a name="107440">If no path is specified for the file data source, the Driver Manager uses the DefaultDSNDir </a>property, which is defined in the <span class="Syntax">[ODBC File DSN]</span> setting in the odbc.ini file to locate file data sources (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 details). If the <span class="Syntax">[ODBC File DSN]</span> setting is not defined, the Driver Manager uses the InstallDir setting in the [ODBC] section of the odbc.ini file. The Driver Manager does not support the SQLReadFileDSN and SQLWriteFileDSN functions.</div> <div class="Body"><a name="107444">As with any connection string, you can specify attributes to override the default values in the </a>data source:</div> <div class="syntax_first"><a name="107445">FILEDSN=/home/users/john/filedsn/Oraclewp2.dsn;UID=james;PWD=test01</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