Skip to main content

   

IBM Redbooks  >  Information Management software




Redbooks Abstract

Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET



Download PDF (3.1 MB)


Get AdobeĀ® ReaderĀ®


Additional Material


View as HTML


Tips for viewing


Order Hardcopy


Others who downloaded this book also downloaded ...

Abstract

Customers have been using the IBM DB2 UDB for iSeries for many years with data access technologies such as ODBC and OLE DB. The newest data access technology from Microsoft is called ADO.NET. Applications that use ADO.NET with the iSeries can work with several different .NET providers:


  • The IBM.Data.DB2.iSeries provider, a .NET-managed provider new to iSeries Access for Windows in V5R3
  • The IBM.Data.DB2 provider, a .NET provider that works with all IBM eServer platforms in conjunction with DB2 Connect
  • The Microsoft System.Data.OleDb provider, as a bridge to one of the OLE DB providers included with iSeries Access for Windows (IBMDA400, IBMDASQL, and IBMDARLA)
  • The Microsoft System.Data.Odbc provider, as a bridge to the ODBC driver included with iSeries Access for Windows

This IBM Redbook shows customers how to use ADO.NET effectively to harness the power of DB2 UDB for iSeries, showing examples, best practices, pitfalls, and comparisons between the different ADO.NET data providers.

Table of Contents

Part 1. Background
Chapter 1. Introduction to DB2 UDB for iSeries
Chapter 2. Introduction to the Microsoft .NET framework
Chapter 3. ADO .NET object hierarchy
Part 2. Providers
Chapter 4. IBM DB2 UDB for iSeries .NET provider
Chapter 5. IBM DB2 for LUW .NET provider
Chapter 6. Selecting the .NET provider
Part 3. Scenarios
Chapter 7. ASP .NET scenario (Web forms)
Appendix A. Sample programs
Appendix B. Additional material

Others who downloaded this publication also downloaded
Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries, SG24-6503-02
IBM System i Overview: Models 515, 525, 550, 570, 595, and More, REDP-5052-00
Getting Started with DB2 Web Query for System i, SG24-7214-00


Profile

Publish Date
13 April 2005

Rating: rating
(based on 16 reviews)

Rate this book

Author(s)
Hernando Bedoya
Carlos Carminati
Lorie DuBois
Jarek Miszczyk
Ajit Mungale

ISBN
0738490555

IBM Form Number
SG24-6440-00

Number of pages
282