Our biggest customer uses an AS400 as their database. The very limited programming I have done for them was years ago using Perl and ODBC. Most of the work we do for them currenty is done in RPG but they are now asking for stuff that is better suited to .NET, specifically ASP.NET, for their customers to view inventory on the web.



I have been looking and have some leads but if someone here has some practical expreience with something that works ( a data provider), I would sure appreciate it.

Keith Chisarik

*wishes for self edit privs again*



Also, the best lead I have would implement an OLEDB solution, I think you guys told me that would work fine with Strataframe, and that I would just lose some of the strong typing benefits and other benefits of a provider written specifically for the data source?

Keith Chisarik

Actually, most of the benefits of the .NET providers written specifically for a database are not used by StrataFrame itself... we have to rely on what's available in the classes in the System.Data.Common namespace to keep SF provider independent.  However, you will get better performance finding a DB2 provider instead of using OLEDB.  I'm pretty sure DataDirect has a good DB2 provider, as does IBM itself.