Re: Data provider question

[BButterworth@xxxxxxxxxxxxxx]

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