Re: C## ASP connecting to AS/400 DB

["Joel Cochran" <joelcochran@xxxxxxxxx>]

Hi Mark,

If he is using ASP.NET with C#, then he will surely want to use the iSeries
.NET Managed Provider.  This comes with iSeries Access V5R3/4. (the iSeries
does not need to be at V5R3+, just iSeries Access on the PC.  It works on
V5R1 OS/400 and better.)  He would need to install it on the IIS server (and
whatever development machine he is using). You could use ODBC instead, but I
have had far better results with the MP.  The on ething to be aware of is
that the iSeries Access installer will NOT install the MP unless you
specifically check the box.  It is in the Data Access portion of the
installer.  The ODBC box and OLE/DB box will be checked, but not the MP.

Oh, and if you are using .NET Framework 2.0, you should read this:
http://www.developingfor.net/net-20/ibm-iseries-net-managed-provider.html

There are other options, such as DataDirect.com, which provides providers,
but I have not used them yet (and this is not an endorsement).  I am going
to give them a try, but they are kind of expensive.  The good thing about
them is you do not need to worry about iSeries Access deployment/licensing,
etc.

HTH,