RE: How do I connect from iSeries to MS SQL Server 2000?

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

Joe said:
> Yup.  I just wanted to be clear that Java is the right road to take
> because it allows so many other options.

Hey, every once in a while Joe and I agree, it's true (quick, go mark
your calendars <G>). Obviously I'm a c# and .NET guy, but I can hack my
way through Java easily enough that using the JDBC drivers to get
something from SQLServer isn't that hard, especially once you've done it
and can copy the code.

Sure, if you're going to write a web front-end, or you're looking for
something more universal I lean toward .NET and as Steve mentions below,
WebServices. But if you need something that's quick and simple use Java
in RPG.

Steve said:
>For example, if an RPG program needs to read rows from a SQLServer
>table, the .NET thing to do is connect to a web service and receive
>the SQL selected rows back as a serialized, self describing, table.  
>Another way is to have a socket connection between the two systems and
>return the serialized data set thru the socket link. 

In a perfect world I'd agree, I'm a strong proponent of WebServices.
However, how will you consume those services from RPG? Again you'd have
to drop to Java to consume them and often the solution needed is quick
and dirty. In the long run a web service would be great, but sometimes
we needn't over complicate the issue. 

Now, if you tell me we need the same data in RPG and in our Cobol
mainframe app and in our C# web site and in our VB thick client app,
well then, web services are the way to go!

-Walden

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

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