Go Mobile 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 13.0.20.2 (in Windows/assembly).  13.0.0.2 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
  • 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=192.168.1.10; UserID=USRPRFNAME; Password=USRPRFPWD; Naming=System; LibraryList=LIBNAME1,LIBNAM2,LIBNAM3;"/>

  • </connectionStrings>




Click below to stream a video preview of the project download included with our POWERUp19 session:
Get Running with IBM's .NET Data Provider and Db2 for i


  • 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


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





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





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





        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
800-739-3777
( please register or sign-in )
© 2019 Tegratecs Development Corp.