Re: iDB2ConversionException on ExecuteNonQuery()onlyon Server

OK, but why does it run on one machine and not the other?

Craig Pelkie

----- Original Message ----- From: "Mike Wills" <koldark@xxxxxxxxx>
To: ".net use with the System i" <systemidotnet@xxxxxxxxxxxx>
Sent: Friday, August 13, 2010 4:23 PM
Subject: Re: [SystemiDotNet] iDB2ConversionException on ExecuteNonQuery()onlyon Server

We got it figured out. I didn't define my parameters right in the program. I should have specified the type and size of the field on the .add(). It's hard to clarify on the iPod Touch, but I can post the answer later.

--
Mike Wills
http://mikewills.info

Sent from my mobile

On Aug 13, 2010, at 5:25 PM, "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx> wrote:

I'd also question if the connection string is the same. Same libraries and user? You're qualifying the proc name (ewww), but that doesn't mean the proc isn't then using the library list for it's function.

-Walden


--
Walden H Leverich III
Tech Software &
BEC - IRBManager
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com
http://www.IRBManager.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Craig Pelkie
Sent: Friday, August 13, 2010 3:20 PM
To: .net use with the System i
Subject: Re: [SystemiDotNet] iDB2ConversionException on ExecuteNonQuery() onlyon Server

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.

--
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.
--
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.

--
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.