Re: Call iSeries program from C# program

["Bob O." <otis_the_cat@xxxxxxxxxxx>]

  It didn't like not having any parameters built for the
  "ExecuteNonQuery()".  I put in a null value and WhaLa!

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

    From:  richard@xxxxxxxxxxx
    Reply-To:  Midrange Systems Technical Discussion
    <midrange-l@xxxxxxxxxxxx>
    To:  midrange-l@xxxxxxxxxxxx
    Subject:  Re: Call iSeries program from C# program
    Date:  Thu, 22 Feb 2007 04:00:46 -0600
    >Maybe you ripped out too much code from the sample.
    >
    >Backtrack to the point you had it working and try again.
    >
    >Also, what OS/400 version are you at and what version of CA/400 Express
    ?
    >
    >I am using the V5R3 version currently.
    >
    >Although that should not really be an issue since you did have it
    working
    >:-)
    >
    >Also you need to put in parameter markers when passing parms.
    >
    >Regards,
    >Richard Schoen
    >RJS Software Systems Inc.
    >"Providing Your....iNFORMATION NOW!"
    >Email: richard@xxxxxxxxxxxxxxx
    >Web Site: http://www.rjssoftware.com
    >Tel: (952) 898-3038
    >Fax: (952) 898-1781
    >Toll Free: (888) RJSSOFT
    >
    >----------------------------------------------------------------------
    >
    >message: 1
    >date: Wed, 21 Feb 2007 14:23:18 -0600
    >from: "Bob O." <otis_the_cat@xxxxxxxxxxx>
    >subject: Re: Call iSeries program from C# program
    >
    >I checked out the article.  I successfully got his little program to
    work
    >(using the system console like he did).  I added the code to my project
    (a
    >
    >windows application) and it would error out on calling the program.  I
    >removed all the parameters since the program I'm trying to call doesn't
    >have
    >any.
    >
    >OleDbCommand cmd = new OleDbCommand("{{call dortest.OR195}}", cn);
    >
    >I got the error:  Value 'DORTES.OR' for PGM exceeds 10 characters.
    >
    >If I add () to the command
    >
    >OleDbCommand cmd = new OleDbCommand("{{call dortest.OR195()}}", cn);
    >
    >I get the error:  Keyword 'DORTEST.OR' not valid for this command.
    >
    >
    >Now why would just taking out the console.write stuff and the un-needed
    >parms cause such a problem?
    >
    >--
    >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
    list
    >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
    >To subscribe, unsubscribe, or change list options,
    >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
    >or email: MIDRANGE-L-request@xxxxxxxxxxxx
    >Before posting, please take a moment to review the archives
    >at http://archive.midrange.com/midrange-l.
    >

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

  Don*t miss your chance to WIN 10 hours of private jet travel from
  Microsoft(R) Office Live