Manually coding your typed data sets and using the standard IBM data
provider (whichever version 5.3-6.1) is in my opinion the easiest option. I
personally have found that when accessing iDB2 data you cannot expect VS2010
to generate all the correct code for you due to differences in SQL syntax
etc. (plus your own design wishes)

It's not very difficult and there is no reason to get other ODBC/OLEDB
drivers involved IMHO

Maurice O'Prey

-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx
[mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of
Sent: 14 July 2010 19:38
To: systemidotnet@xxxxxxxxxxxx
Subject: Re: [SystemiDotNet] Data provider question

My goal, in part, is to create a typed dataset, I've determined that in
order to have access to the MS ODBC driver in Data Sources or Database
Explorer, I need the full-blown version of VS Studio, and I'm having
trouble with the IBM 6.1 data provider. I can add it as a reference to my
project, but when I try to add it to the toolbox, I get an error that "the
assembly's manifest definition does not match the assembly reference" even
though the assembly in the GAC is version and the one in the IBM
i Access folder (IBM.Data.DB2.iSeries.dll) is I updated Access
to 6.1 last night, so I'm not sure if there is a problem with my machine
due to a previous version of Access, or if it is something with the new
IBM data provider. I suppose I can manually code my typed datasets.



message: 2
date: Wed, 14 Jul 2010 08:52:03 -0500
from: Mike <koldark@xxxxxxxxx>
subject: Re: [SystemiDotNet] Data provider question

You can add the IBM driver to your References. From there you can use a
DataSet.xsd object or what I have found is that the connection is faster
when you code your own own connection.

If you want to make use the of the entity framework, I have basic sample
setting that up as well.

Mike Wills

On Wed, Jul 14, 2010 at 8:43 AM, <BButterworth@xxxxxxxxxxxxxx> wrote:

Hello Everyone:

I am working on a Windows Form application and am using IBM i Access 6.1
and VS Express 2010 to develop it. Is the best data provider to use to
connect to DB2 for IBM i the one provided with Access? I'm asking
it would be nice to use a provider that integrates with the Data Sources
or Database Explorer windows in Visual Studio, and I'm not sure that the
Access data provider has this functionality. Is it possible to use an
or OleDB provider provided by MS or IBM, which integrates with VS? Right
now, the only eligible providers/data sources are MS SQL Server or
and it isn't clear to me how to add another provider that could be used
access DB2? (Maybe it's not possible in VS 2010, but I haven't had much
luck figuring this out by searching online.) Any advice, links or
direction would be much appreciated.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].