Hi
The .net provider for iseries is native to VB in that all of the classes are
written in a .net language (ie. Compiles to MSIL). But I think what the VB
developer is talking about is, LINQ (but pronounced LINK). This is language
integrated query, and is a syntax that can be learnt once and applied to
querying XML, SQL and other things.
Its very powerful and a fantastic piece of work, but at the end of the day
its syntactic sugar, if you want to get data from a remote database you need
to connect to it, end of.
You can think of LINQ as a native version of SQL, sort of.
I'm not sure, but it should be possible to use it with any .net (ADO.net
driver) and if it isn't possible, it suggests that it is an attempt from
Microsoft to reduce the number of viable database servers that can be used
with VB, c# etc.... and that doesn't seem likely.
Neill
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: 04 December 2008 19:01
To: Midrange Systems Technical Discussion
Subject: RE: VB Native Data Access on i-series database
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
