Re: Host Integration Server & AS400 SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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