Use OleDB DB2 provider type without extra software?

[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)?

 

[Guest]

ajmastrean,

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

Provider=DB2OLEDB

See www.ConnectionStrings.com for an example.

Kerry Moorman

 

[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.

 

[Paul Clement]

¤ 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)

 

[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]