RE: Accessing Service Programs from .NET

Donald,

Are you sure about the stored procedure/OPM connection?  One of our developers 
here recently did some work for a VB (Don't know if it is .NET) application and 
I'm sure it was done in ILE.  In fact, I'm pretty sure SQL wanted to know the 
name of the service program and procedure.  Maybe it's release specific.  What 
release are you on?  We are at V5R3.

I also think you could use the SQL CALL option.  I don't have experience in 
that area but I'm sure others on the list do.

HTH,

Rick

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Fisher, Don
Sent: Thursday, November 10, 2005 11:56 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Accessing Service Programs from .NET


I have not found much so far to help with this in the archives or the
manuals. 

We have agreed to have another company manage our web presence using a
package that company has developed.  The other company uses .NET (C#) over
SQL Server as its development environment.

These programs need to be able to execute procedures we have embedded in
service programs on our iSeries (V5R2) to retrieve different information
stored on our iSeries so we won't have business logic stored in more than
one place.  Stored procedures apparently only work with an OPM model and
user defined functions must apparently be used in a "Select" statement.

Communication via sockets is potentially an option and I do have Scott
Klement's excellent sockets tutorial.

If it matters, communication with our iSeries will be over a point to point
T1 line from a remote site.

I would greatly appreciate any advice, samples, or RTFM pointers.

Thank you.

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx


Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.