× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Do you have the same version of IBM i Access and the same Service Level on both the PC and the server?

Craig Pelkie


----- Original Message ----- From: "Mike" <koldark@xxxxxxxxx>
To: <systemidotnet@xxxxxxxxxxxx>
Sent: Friday, August 13, 2010 8:06 AM
Subject: [SystemiDotNet] iDB2ConversionException on ExecuteNonQuery() onlyon Server


I have a strange error I am trying to figure out. I am getting
a DB2ConversionException on an ExecuteNonQuery(). I am running a stored
procedure that calls an RPG program. This works perfect on my own PC.
However, when I publish it to the web server, I get the error.

public void SignTimeSheet(Timesheet timesheet, string approved)
{
// Get the data from the iSeries
using (iDB2Connection conn = new iDB2Connection(_CONNSTRING))
{
conn.Open();

iDB2Command cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;

if ((String.IsNullOrEmpty(timesheet.SupervisorComments)) &&
(approved == " "))
{
cmd.CommandText = "MPRLIB.APPROVETIMESHEET";

cmd.Parameters.Add("@SSN",
timesheet.EmployeeUniqueKey.ToString("0000000000"));
cmd.Parameters.Add("@PAPER",
timesheet.EmployeeSignedPaper);
cmd.Parameters.Add("@SUPERVISORID",
timesheet.SupervisorUserId);
cmd.Parameters.Add("@SIGNEDUSER",
timesheet.SupervisorSignedBy);
cmd.Parameters.Add("@WORKSTATION",
timesheet.SupervisorSignedComputer);
}
else
{
cmd.CommandText = "MPRLIB.APPROVETIMESHEETWCOMMENT";

cmd.Parameters.Add("@SSN",
timesheet.EmployeeUniqueKey.ToString("0000000000"));
cmd.Parameters.Add("@PAPER",
timesheet.EmployeeSignedPaper);
cmd.Parameters.Add("@APPROVE", approved);
cmd.Parameters.Add("@SIGNEDUSER",
timesheet.SupervisorSignedBy);
cmd.Parameters.Add("@WORKSTATION",
timesheet.SupervisorSignedComputer);
cmd.Parameters.Add("@COMMENT",
timesheet.SupervisorComments);
}

cmd.ExecuteNonQuery();
conn.Close();
}
}

Any ideas on what it might be or how to debug this on the server?

--
Mike Wills
http://mikewills.info
--
This is the .net use with the System i (SystemiDotNet) mailing list
To post a message email: SystemiDotNet@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/systemidotnet.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.