See here:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.
ibm.db2.udb.dndp.doc/htm/frlrfIBMDataDB2.htm
DB2 .NET Data Provider
The DB2 .NET Data Provider extends DB2 support for the ADO.NET
interface. The DB2 .NET Data Provider delivers high-performing, secure
access to DB2 data.
The DB2 .NET Data Provider allows your .NET applications to access the
following database management systems:
DB2 Universal Database Version 8 for Windows, UNIX, and Linux-based
computers
DB2 Universal Database Version 6 (or later) for OS/390 and z/OS, through
DB2 Connect
DB2 Universal Database Version 5, Release 1 (or later) for AS/400 and
iSeries, through DB2 Connect
DB2 Universal Database Version 7.3 (or later) for VSE & VM, through DB2
Connect
In addition to the DB2 .NET Data Provider, there is also a collection of
add-ins to the Microsoft Visual Studio .NET IDE. These add-ins simplify
the creation of DB2 applications that use the ADO.NET interface. You can
also use these add-ins to develop server-side objects, such as SQL
stored procedures and user-defined functions.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Grizzly Malchow
Sent: Thursday, December 04, 2008 11:30 AM
To: Midrange Systems Technical Discussion
Subject: RE: VB Native Data Access on i-series database
There is a DB2 .net Data Provider.
I would have to assume your VB guys are already aware if it, unless they
have never tried to access a DB2 database with .net.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
Sent: Thursday, December 04, 2008 10:43 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: VB Native Data Access on i-series database
Below is what I found (Again, I'm not familiar with VB at all):
Statement below uses ODBC:
Dim cmdMcbellRead As New OdbcCommand("SELECT REFKEY,
SUBSTRING(REFDAT,1,30) FROM " & libBOSS & ".REFERPL10 WHERE REFCAT='CUC'
AND SUBSTRING(REFDAT,31,3)='NAT'", cnMcBell1)
Statement below uses native access (which he said is not support for
iseries database):
Dim cmdSalesDelete As New SqlCommand("Delete From dbo.NAMGroups",
cnSales)
"Grizzly Malchow" <grizzlym@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:<mailman.7526.1228406010.13295.midrange-l@xxxxxxxxxxxx>...
I'm not sure what Native Database Access for VB is, but I know OLEDB and
ADO can be used in VB to access the DB2 database on the System i. If I
remember correctly Client Access has data providers for ODBC, OLEDB, and
ADO. All of which can be used in VB provided that Client Access is
installed.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
