RE: VB Native Data Access on i-series database

[Grizzly Malchow <grizzlym@xxxxxxxxxxxxxxxxxxxxx>]

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.