IBM DB2 .NET provider - Where/how do you get it?

[Mr. K.V.B.L.]

Thanks!

[CRPence]

The .NET Data Provider is delivered with iSeries Access; named
IBM.Data.DB2.iSeries
Searching InfoCenter for ".net data provider" finds the following,
and more. For example:

Giving selective install details:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaik/rzaikdotnetprovider.htm

"The IBM.Data.DB2.iSeries data provider complements the existing OLE
DB database providers. It allows you to use Visual Basic and C# to
develop your .NET client/server applications. You can use the
Programmer's Toolkit along with this provider to make development of
your .NET Windows® client PC applications quicker and easier."

"The Managed Provider follows the .NET Framework specifications for
managed code, including the requirement to have the .NET Framework
already installed on your PC. Once it is installed, follow these steps
to install the provider using Selective Setup:
Start > Programs > IBM iSeries Access for Windows > Selective Setup
On the Component Selection panel, in the Data Access component select
.NET Data Provider.
Continue through the Selective Setup wizard.
See Microsoft® Web site for the architecture and details on Microsoft's
.NET Framework, ADO.NET, Windows Installer, GAC, the CLR, and
specifications for managed code."

"To access technical details:
The IBM DB2 UDB .NET Provider Technical Reference, which is shipped with
the iSeries Access for Windows product, provides complete documentation
of the Managed Provider's support. To access this information, use this
path: Start > Programs > iSeries Access for Windows > Programmer's
Toolkit > Programmer's Toolkit > Common Interfaces > ADO.NET."

The following explains that the although delivered in a separate
purchasable product, is available without licensing under that product;
only access to the i5/OS is required.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaij/rzaijlicenseinfo.htm

The following gives a link to the first, and other information:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaii/rzaii3tiertechs.htm

A google search:
http://www.google.com/search?hl=en&q=iseries+db2+.net+site%3Aibm.com
http://www.ibm.com/systems/i/software/db2/awp.html
http://www.ibm.com/systems/i/access then drill down to
http://www.ibm.com/systems/i/software/access/windows/dotnet/
The above will link also gives the following link for the latest, a
preview/trial for "iSeries Access for Windows and ADO .NET 2.0":
http://www.ibm.com/systems/i/software/access/planning.html

Regards, Chuck
--
All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor views of my
employer

Mr. K.V.B.L. wrote:
> IBM DB2 .NET provider - Where/how do you get it?

[Thorbjoern Ravn Andersen]

CRPence <crp...@vnet.ibm.com> writes:

> The .NET Data Provider is delivered with iSeries Access; named
> IBM.Data.DB2.iSeries

If the "must install iSeries Access" is for some reason out of the
question, I have seen[1] that the jt400 driver for Java can be made
available to .NET programs by compiling to CIL with ikvm.

http://blogs.rjssoftware.com/rjsblog/index.php/2006/05/24/use-java-libraries-such-as-jtopenjt400-in-your-net-applications/

(searched for "ikvm jt400" on Google)

I have not tried this myself.
--
Thorbjørn Ravn Andersen

[Mr. K.V.B.L.]

Ok, we have V5R2 but I'll assume it's available for download
somewhere. I don't see if on my CA install disk.

On Nov 20, 6:48 pm, CRPence <crpe...@vnet.ibm.com> wrote:
> The .NET Data Provider is delivered with iSeries Access; named
> IBM.Data.DB2.iSeries
> Searching InfoCenter for ".net data provider" finds the following,
> and more. For example:
>

> Giving selective install details:http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic...

>
> "The IBM.Data.DB2.iSeries data provider complements the existing OLE
> DB database providers. It allows you to use Visual Basic and C# to
> develop your .NET client/server applications. You can use the
> Programmer's Toolkit along with this provider to make development of

> your .NET Windows(R) client PC applications quicker and easier."
>

[Richard Schoen]

The JT400 technique works well as has NO iSeries access requirements.

Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: ric...@rjssoftware.com
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT

"Thorbjoern Ravn Andersen" <nospa...@gmail.com> wrote in message
news:yu2fxz0...@luhmann.netc.dk...

[CRPence]

If there is a v5r4 [& v5r3?] server available with the product
[5722XE1 or is it 5722XW1] installed that delivers iSeries Access, the
following would be a way to install it from there when a v5r4 install
disk is not available:

Map a drive to \\server\root [the root directory] of the named
server. Drill down to the following application and run it:
/qibm/proddata/access/Windows/Install/Image/setup.exe
Choose selective install, and in the list of components presented for
the selective install, choose to install from the "Data Access" group,
the ".NET Data Provider".

Regards, Chuck
--
All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor views of my
employer