IBM Data Provider for .NET

[Wallace B. McClure]

Does anyone out there have any experience using the IBM iSeries / AS400 .NET
Data Provider? I'm trying to use it, but I am getting some weird errors
that I don't understand.

Wally

[Wallace B. McClure]

The specific error message that I am getting is:

Server Error in '/MagnatronImageGenerator' Application.
--------------------------------------------------------------------------------

SQL0204 OER4016A in DIST2000C type *N not found.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: IBM.Data.DB2.iSeries.iDB2SQLErrorException: SQL0204
OER4016A in DIST2000C type *N not found.

Source Error:

Line 534: //iDB2Cm.CommandType = CommandType.StoredProcedure;
Line 535: //iDB2Cm.Connection = iDB2Cn;
Line 536: iDB2Cm.DeriveParameters();
Line 537: iDB2Cm.Parameters["@PARM"].Value = strPARAM;
Line 538: iDB2Cm.ExecuteNonQuery();

Source File: c:\WebSites\MagnatronImageGenerator\DynamicImage.aspx.cs
Line: 536

Stack Trace:

[iDB2SQLErrorException: SQL0204 OER4016A in DIST2000C type *N not found.]
IBM.Data.DB2.iSeries.iDB2Exception.throwDcException(MpDcErrorInfo mpEI,
MPConnection conn) +269
IBM.Data.DB2.iSeries.iDB2Command.reportDCError(Int32 rc) +676
IBM.Data.DB2.iSeries.iDB2Command.Prepare() +452
IBM.Data.DB2.iSeries.iDB2Command.DeriveParameters() +892
DynamicImage.GetAS400Contents() in
c:\WebSites\MagnatronImageGenerator\DynamicImage.aspx.cs:536
DynamicImage.GetFileCommands() in
c:\WebSites\MagnatronImageGenerator\DynamicImage.aspx.cs:464
DynamicImage.Page_Load(Object sender, EventArgs e) in
c:\WebSites\MagnatronImageGenerator\DynamicImage.aspx.cs:28
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o,
Object t, EventArgs e) +31
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +68
System.Web.UI.Control.OnLoad(EventArgs e) +88
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3037

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42

"Wallace B. McClure" <wal...@notonyourlife.com> wrote in message
news:e7ov8a$1oc3u$2...@news.boulder.ibm.com...

[Wallace B. McClure]

The source code that I think is important is:
strCm = "CALL DIST2000C.OER4016A(@PARM, @SESSION)";

iDB2Cn.Open();

iDB2Cm = iDB2Cn.CreateCommand();

iDB2Cm.CommandText = strCm;

iDB2Cm.DeriveParameters();

"Wallace B. McClure" <wal...@notonyourlife.com> wrote in message
news:e7ov8a$1oc3u$2...@news.boulder.ibm.com...

[Wallace B. McClure]

I think that we have found the cause of our error. We needed to have a
sproc setup to call the cl program.

Wally

"Wallace B. McClure" <wal...@notonyourlife.com> wrote in message

news:e7ovhb$1hk22$1...@news.boulder.ibm.com...