Use OleDB DB2 provider type without extra software?

20 Dec 2006 8:42 PM

ajmastrean

I recently realized that I need IBM's iSeries Access installed to use
Provider=IBMDA400.DataSource.1 in an OleDB connection string.

Is there any .NET 2.0 class or dll that provides DB2 data access
without any other software installs besides the .NET 2.0 Framework? Or,
alternatively, can I pack whichever specific class/dll provides
IBMDA400.DataSource.1 into the project itself (and not as a reference
to it externally)?

21 Dec 2006 12:37 AM

Kerry Moorman

ajmastrean,

I believe that you can use Microsoft's OleDb provider:

Provider=DB2OLEDB

See www.ConnectionStrings.com for an example.

Kerry Moorman

Show quote

"ajmastrean" wrote:

> I recently realized that I need IBM's iSeries Access installed to use
> Provider=IBMDA400.DataSource.1 in an OleDB connection string.
>
> Is there any .NET 2.0 class or dll that provides DB2 data access
> without any other software installs besides the .NET 2.0 Framework? Or,
> alternatively, can I pack whichever specific class/dll provides
> IBMDA400.DataSource.1 into the project itself (and not as a reference
> to it externally)?
>
>

21 Dec 2006 1:25 PM

ajmastrean

I am actually being told that that provider is not registered on my
machine. I have done some searching (in the groups and other forums)
and it seems a separate client needs to be installed to use that
provider as well.

21 Dec 2006 3:32 PM

Paul Clement

On 21 Dec 2006 05:25:17 -0800, "ajmastrean" <ajmastr***@gmail.com> wrote:

¤ I am actually being told that that provider is not registered on my
¤ machine. I have done some searching (in the groups and other forums)
¤ and it seems a separate client needs to be installed to use that
¤ provider as well.

Correct. There is no DB2 provider (or client software) that is installed by Microsoft.

Paul
~~~~
Microsoft MVP (Visual Basic)

28 Dec 2006 8:45 PM

Kevin S Gallagher

To use the IBM native ADO.NET provider you need to install it from Client
Access which I believe is a free download. Add the reference in
IBM.Data.DB2.iSeries.dll followed by [Imports IBM.Data.DB2.iSeries]

Show quote

"ajmastrean" <ajmastr***@gmail.com> wrote in message
news:1166647365.935012.177930@a3g2000cwd.googlegroups.com...
>I recently realized that I need IBM's iSeries Access installed to use
> Provider=IBMDA400.DataSource.1 in an OleDB connection string.
>
> Is there any .NET 2.0 class or dll that provides DB2 data access
> without any other software installs besides the .NET 2.0 Framework? Or,
> alternatively, can I pack whichever specific class/dll provides
> IBMDA400.DataSource.1 into the project itself (and not as a reference
> to it externally)?
>