That's it....
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Neill Harper
Sent: Thursday, December 04, 2008 2:42 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: VB Native Data Access on i-series database
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.
--
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
