Log In
       Where ERP Meets the Web

Getting the
Db2 for i .NET Data Provider
Up and Running

  • Let us help you with Q&A, providing examples or custom development contracting
  • We can help you formulate strategy, train your resources or do the development

  • Use Visual Studio IDE and c#, VB.NET or 3rd Party Languages such as ASNA's Visual RPG for .NET

  • Installing and Specifying Settings (Plumbing)(Call Us if you get stuck!)
  • for a website project or a web app, installation of the .NET Data Provider is the only component that is required on Windows Server running IIS and development workstations, so specify custom install
  • Select the features you want installed...
  • the latest version of the .dll shows File Version (in Windows/assembly). is quite a bit older but works fine in a lot of cases, provided it was installed properly 
  • get the full scoop on downloading and installing the latest version of the ACS Windows Application Package, without registering on the website by attending our new presentation at POWERUp19™, Get Running with the IBM .NET Data Provider and Db2 for i  (included hand-outs and downloads no longer visible now that the conference is over)
  • The SQL features available to use will be based on the IBM i server OS level.  Similarly, the .dll works fine with i5/OS V5R4 through IBM i 7.3 and .NET FW projects compiled all the way up to the latest, such as FW 4.7.2 (provided the web.config file specifies the .dll to run at v2.0.50727)

  • connection strings can take advantage of *LIBL technique (with Db2 for i version only)

  • Eliminate library and schema and testing-based hard-coding with library list technique!

    Please use the Contact Us phone number and extension for a no-cost, no-obligation discussion.  Or register and get a free code snippet of your choosing.

  • Here is a connection string example from a web.config file, based on a working production version, using the library list technique.  Remember to create your stored procedure and SQL PL with compatible syntax and options based on the system naming technique. 

  • <connectionStrings>

  • <add name="strDotNetDB2iCnnName" connectionString="DataSource=; UserID=USRPRFNAME; Password=USRPRFPWD; Naming=System; LibraryList=LIBNAME1,LIBNAM2,LIBNAM3;"/>

  • </connectionStrings>

  • Use inline SQL or stored procedure calls

  • Use Equivalent Constructs as with Other Data Providers for .NET Environment
  • define methods for Db2 for i access at the same scope and with the same functional equivalent as with those for MS SQL Server
  • most adapters are supported
  • populate and work with .NET FW OO dataset objects that were created via drag and drop from Db2 for i file columns and subsets
  • we like to characterize dataset objects as multi-occurrence data structures on steroids
  • you can even qualify to the column names based on ALIAS names, thus enabling verification of column names and data type and OO object compatibility at compile time

IBM.Data.DB2.iSeries.dll illustration

Microsoft Visual Studio Professional 2015 picture (for illustrative purposes only)

IBM Db2 for i picture (for illustrative purposes only)

  • Let us help you with development services or to supply examples
  • We can help you formulate strategy, train your resources or do the development
Continue to Next Page in Series

Click below to stream 5 minute video:
Part 2 - Using Navigator for i to Update a Db2 for i v7r2 SQL PL Stored Procedure
with *LIBL and Record Lock features

Click below to stream 5 minute video (must be logged in):
Part 1 - Using System i Navigator to Update an SQL PL Stored Procedure on i5/OS V5R4 (quite old version)
with *LIBL and Record Lock features

        go to the home page Top of Featured Services     go to next series page Next in Featured Services     Site Map     Switch to
Mobile View

You are at the web site of Tegratecs Development Corp.  Click here to go to the home page of this site...
Integrity, Integration and ROI from Your Software
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
( please register or sign-in )
© 2009-2019 Tegratecs Development Corp.