News

Copyright © 2008-2019 Paula DiTallo

Tag Cloud


<< Why Won't the Relationship Lines in Visio 2010 Connect to Anything? | Home | How do I get a listing of all DB instances and table names where a column name occurs in MS SQL Server? >>

How do I get access to DB2 from my .NET applications?

 

You have at least 2 choices:

Source 1: SQL Server 2008 Feature Pack
 
... this includes Microsoft OLEDB Provider for DB2
 
Source 2: Available from IBM, is the IBM I Access pack
 
Remember, whichever one you use, you will need to specifiy which libraries under the detail/advance settings in ODBC.
Tuesday, September 13, 2011 2:08 PM

Feedback

# re: How do I get access to DB2 from my .NET applications?

What has been said so far assumed "DB2" is DB2 for iSeries. There is another way, which may be more benefit for .Net developers.

IBM's DB2 Connect product provides a "gateway" to "host" DB2 servers (iSeries and DB2 for z/OS). You communicate with the server using the DRDA protocol, common across the DB2 family. You need to set up an RDB (DRDA endpoint) on the iSeries.

You can then use the standard IBM Data Server Client, which includes a variety of development tools which are extremely useful.

In particular you get plugins for Visual Studio which make DB2 development virtually no different from development for other (potentially more common) .Net data sources.

You also can use other programming languages including Java, Perl, PHP, Ruby and Python (as well as C, COBOL and REXX if you come from that background).

You can also set up federated links to the iSeries to take advantage of the more advanced SQL available on the DB2 for LUW (Linux, UNIX and Windows) platform if you wish. 9/19/2011 3:52 AM | Philip Nelson

# re: How do I get access to DB2 from my .NET applications?

Philip,
Thanks so much for augmenting what's here! 9/19/2011 9:31 AM | paula
Post A Comment
Title:
Name:
Email:
Comment:
Verification: