ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzaii_5.4.0.1/rzaiiodbcprvntproggensrc.htm

91 lines
5.0 KiB
HTML
Raw Permalink Normal View History

2024-04-02 14:02:31 +00:00
<?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 lang="en-us" xml:lang="en-us">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="security" content="public" />
<meta name="Robots" content="index,follow" />
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
<meta name="DC.Type" content="concept" />
<meta name="DC.Title" content="ODBC policy: Prevent use of program generated data sources" />
<meta name="abstract" content="Use this policy to restrict the use of program generated data sources when using iSeries Access for Windows ODBC support." />
<meta name="description" content="Use this policy to restrict the use of program generated data sources when using iSeries Access for Windows ODBC support." />
<meta name="DC.Relation" scheme="URI" content="rzaiiodbcfunction.htm" />
<meta name="DC.Relation" scheme="URI" content="rzaiiodbcprvntnameddatasrc.htm" />
<meta name="DC.Relation" scheme="URI" content="rzaiiodbcprvntnameddatasrc.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="rzaiiodbcprvntproggensrc" />
<meta name="DC.Language" content="en-us" />
<!-- All rights reserved. Licensed Materials Property of IBM -->
<!-- US Government Users Restricted Rights -->
<!-- Use, duplication or disclosure restricted by -->
<!-- GSA ADP Schedule Contract with IBM Corp. -->
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
<link rel="stylesheet" type="text/css" href="./ic.css" />
<title>ODBC policy: Prevent use of program generated data sources</title>
</head>
<body id="rzaiiodbcprvntproggensrc"><a name="rzaiiodbcprvntproggensrc"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">ODBC policy: Prevent use of program generated data sources</h1>
<div><p>Use this policy to restrict the use of program generated data sources
when using iSeries™ Access
for Windows<sup>®</sup> ODBC
support.</p>
<p>A "program generated data source" is one that is created temporarily when
an ODBC connection is made without using the DSN option to specify the name
of the data source. Note that use of the FILEDSN option does not mean the
data source used is named. FILEDSN simply specifies the name of a file containing
connection options, not the name of a data source.</p>
<p>If a program first creates a data source (using SQLCreateDataSource, for
example) and then connects using the DSN option, the data source is not considered
a program generated data source, but a named data source. To restrict the
use of named data sources, use the Prevent use of named data sources policy.</p>
<p>This policy is an override of <span class="uicontrol">machine setting enabled</span>.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="border" border="1" rules="all"><thead align="left"><tr><th colspan="3" valign="top" id="d0e40">Policy Type</th>
</tr>
</thead>
<tbody><tr><td rowspan="2" valign="top" headers="d0e40 ">Restriction</td>
<td colspan="2" valign="top" headers="d0e40 ">Configuration</td>
</tr>
<tr><td valign="top" headers="d0e40 ">Suggestion</td>
<td valign="top" headers="d0e40 ">Mandate</td>
</tr>
<tr><td valign="top" headers="d0e40 ">X</td>
<td valign="top" headers="d0e40 "> </td>
<td valign="top" headers="d0e40 "> </td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="border" border="1" rules="all"><thead align="left"><tr><th colspan="4" valign="top" id="d0e68">Policy Scope</th>
</tr>
</thead>
<tbody><tr><td valign="top" headers="d0e68 ">Per PC (all users)</td>
<td valign="top" headers="d0e68 ">Per user</td>
<td valign="top" headers="d0e68 ">Per user setting (May override machine setting)</td>
<td valign="top" headers="d0e68 ">Per iSeries connection</td>
</tr>
<tr><td valign="top" headers="d0e68 ">X</td>
<td valign="top" headers="d0e68 ">X</td>
<td valign="top" headers="d0e68 "> </td>
<td valign="top" headers="d0e68 ">X</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaiiodbcfunction.htm" title="Control ODBC functions by policies.">Policies by function: ODBC</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="rzaiiodbcprvntnameddatasrc.htm" title="Use this policy to restrict the use of named data sources when using iSeries Access for Windows ODBC support.">ODBC policy: Prevent use of named data sources</a></div>
</div>
</div>
</body>
</html>