ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzaik_5.4.0.1/rzaikoledbprovider.htm

97 lines
5.7 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="reference" />
<meta name="DC.Title" content="iSeries Access for Windows OLE DB provider" />
<meta name="abstract" content="Supports record-level access and SQL access to iSeries database files. Use the ActiveX Data Objects (ADO) and the OLE DB interfaces to take advantage of this support." />
<meta name="description" content="Supports record-level access and SQL access to iSeries database files. Use the ActiveX Data Objects (ADO) and the OLE DB interfaces to take advantage of this support." />
<meta name="DC.Relation" scheme="URI" content="rzaikcaapidb.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 1999, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1999, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="oledbprovider" />
<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>iSeries Access
for Windows OLE
DB provider</title>
</head>
<body id="oledbprovider"><a name="oledbprovider"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">iSeries Access
for Windows OLE
DB provider</h1>
<div><p>Supports record-level access and SQL access to iSeries™ database
files. Use the ActiveX Data Objects (ADO) and the OLE DB interfaces
to take advantage of this support.</p>
<div class="section"><p>The iSeries Access
for Windows<sup>®</sup> OLE
DB Providers, along with the Programmer's Toolkit, make iSeries client/server
application development quick and easy from the Windows client PC. The iSeries Access
for Windows OLE
DB Provider component gives iSeries programmers record-level access interfaces
to iSeries logical
and physical DB2
Universal Database™ (UDB) for iSeries database files. In addition,
they provide support for SQL, data queues, programs, and commands. If you
use Visual Basic, the Visual Basic Wizards make it simple and easy to develop
customized, working applications.</p>
</div>
<div class="section"><p>ADO and OLE DB standards provide programmers with consistent interfaces
to iSeries server
data and services. All three of the providers (the <strong>IBMDA400</strong>, the <strong>IBMDASQL</strong>,
and the <strong>IBMDARLA</strong>) handle all iSeries server-to-PC and data type-to-data
type conversions.</p>
</div>
<div class="section"> <dl><dt class="dlterm">To install OLE DB Provider:</dt>
<dd>When you install iSeries Access for Windows(or when you run <strong>Selective
Setup</strong> if iSeries Access
for Windows is
installed), select the <strong>Data Access</strong> component. Make sure that the <strong>OLE
DB Provider</strong> subcomponent also is selected. <div class="note"><span class="notetitle">Note:</span> The OLE DB Provider will
not be installed if the computer does not have MDAC 2.5 or later installed,
before installing iSeries Access for Windows. MDAC can be downloaded from Microsoft<sup>®</sup>:
www.microsoft.com/data/doc.htm.</div>
</dd>
<dt class="dlterm">To access OLE DB Technical Reference:</dt>
<dd>The iSeries Access
for Windows OLE
DB Technical Reference, which is shipped with iSeries Access for Windows,
provides complete documentation of OLE DB Provider support. To access it from
the Programmer's Toolkit, select <span class="menucascade"><span class="uicontrol">Overview</span> &gt; <span class="uicontrol">Common Interfaces</span> &gt; <span class="uicontrol">ADO/OLE DB</span></span>.</dd>
<dt class="dlterm">To install Programmer's Toolkit and the iSeries ADO Wizards for Visual Basic:</dt>
<dd>When you install iSeries Access for Windows (or when you run <strong>Selective
Setup</strong> if iSeries Access
for Windows is
installed), select the <strong>Programmer's Toolkit</strong> component. See <a href="rzaikinstalltoolkit.htm#installtoolkit">Install the Programmer's Toolkit</a> for
more information.</dd>
</dl>
</div>
<div class="section"><div class="p"><strong>Other OLE DB information resources:</strong> <ul><li><a href="http://www.ibm.com/eserver/iseries/access/oledb" target="_blank">IBM<sup>®</sup> <span class="keyword">iSeries Access for Windows</span> OLE
DB Support Web site.</a><img src="www.gif" alt="Link outside Information Center" /></li>
<li>IBM Redbook <a href="http://www.redbooks.ibm.com/abstracts/sg245183.html" target="_blank">Fast
Path to iSeries Client/Server
Using iSeries OLE
DB Support: SG24-5183</a> <img src="rbpdf.gif" alt="Link to PDF" /></li>
</ul>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaikcaapidb.htm" title="iSeries Access for Windows provides multiple programming interfaces for accessing database files on the iSeries server.">iSeries Access for Windows: Database programming</a></div>
</div>
</div>
</body>
</html>