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 12.0.0.0 and the one in the IBM
i Access folder (IBM.Data.DB2.iSeries.dll) is 12.0.0.0. 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.

Blake


------------------------------

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
of
setting that up as well.

--
Mike Wills
http://mikewills.info


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
because
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
ODBC
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
Access,
and it isn't clear to me how to add another provider that could be used
to
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.

Thanks,
Blake

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2020 by midrange.com 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].