Re: Host Integration Server & AS400 SQL

Hi, 

Thanks a lot for all the input, guys. It looks like SQL Server ( and Host 
Integration server together ) allows VB and C++ applications running on the 
W2K box to access AS/400 data via DRDA ( I still cannot figure out why ODBC 
cannot be used ). However, the requirement is to use an RPG program ( with or 
without embedded SQL ) to read the MS SQL Server 2000 data. And it looks like 
host integration server is not the way to go. But as Vern pointed out, DB2 
Relational connect might just do the trick. Now to go and find an "Evaluation 
version" of the software :)

Thanks again
Narayanan R Pillai
Senior Technical Architect
American Medical & Life Insurance


On Tuesday 07 January 2003 17:17, Vern Hamberg wrote:
> John, SQL Server will not appear unless you have something else on the SQL
> Server box, like Host Integration, or whatever it's called. ADDRDBDIRE has
> to refer to a DRDA connection, and SQL Server doesn't do that. Unless you
> have an application requester driver we don't know about.  <g>
>
> Cheers
>
> Vern
>
> At 02:58 PM 1/7/2003 -0500, you wrote:
> >Try going into SQL via STRSQL
> >Key in CONNECT  (or press F4 and take option 5)
> >Take Option 1 (Remote)  Press enter
> >Press F4 for a list of servers to see what shows up.
> >If your SQL Server doesn't show up you may have to ADDRDBDIRE to add the
> >Data Base.
> >
> >You should be able to connect.   Try a SELECT Statement.
> >
> >Get it to work interactively then embed it in an RPGIV program.
> >
> >
> >John Carr
> >
> >A site for those looking for a Integral approach to reality..
> >
> >http://www.integralinstitute.org/home.cfm
> >
> >or for some fun..
> >
> >http://www.gwbush.com/store/
> >http://www.gwbush.com/
> >
> >
> >
> >-------------------------------------------
> >
> >
> >Hi All,
> >
> >We have a requirement to read data resident on a
> >Windows 2000 SQL Server, from a RPG program running on
> >the AS/400. Somebody pointed the way to Host
> >Integration server running on the Win2K server as the
> >way to go.
> >
> >1. Is this the way to go ?
> >2. Are there other ways to do this ?
> >
> >Regards
> >Narayanan R Pillai
> >Senior Technical Architect
> >American Medical & Life Insurance
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.