"Raoul Laoyan" <RaoulLaoyan@hotmail.com> wrote in message
news:167e401c44837$a878b2a0$a601280a@phx.gbl...
> If this is just a straight import, look to using FTP if
> the daemon is running on the AS/400. You may need to get
> a userid/password on the AS/400 for this task.
>
> If it's bidirectional interchange your looking for, look
> into loading the AS/400 client with the database
> connectivity packages onto the SQL Server itself. Talk
> to your AS/400 systems administrator for this client.
>
> Loading up Host Integration Server would be such a waste
> of time and resource just for one particular task.
>
> Good luck,
>
>
> >-----Original Message-----
> >Partha,
> >Thank you very much for your response; I am aware that
> the Host Integration
> >Server will interface with as400, but can you give me
> some information on
> >how to link the servers programmatically? Additionally,
> can you tell me
> >where to get the oledb provider for db2?
> >
> >Regards,
> >
> >Sean Gahan
> >
> >"Partha Mandayam" <mcp111@hotmail.com> wrote in message
> >news:e%23l4YMSREHA.1620@TK2MSFTNGP12.phx.gbl...
> >> You should create a linked server to as400 using
> Microsoft oledb
> >> provider for db2 and then access the data using
> openquery
> >>
> >> Regards
> >>
> >> Partha Mandayam
> >> Software Consultant
> >> Home page: http://partha.tripod.com
> >>
> >>
> >> *** Sent via Developersdex
> http://www.developersdex.com ***
> >> Don't just participate in USENET...get rewarded for it!
> >
> >
> >.
> >