AS/400 Linked Server

Hello. Anyone know how what's needed to connect to an
AS/400 from SQL Server via a Linked Server? Any special
Provider softwre need to be in place? Any references on
this would help. THanks a lot... BruceBruce,
Try the MS Host Integration Server Administration Client .What you should be
installing is Microsoft ODBC Driver for DB2.
Refer
INF: Configuring Data Sources for the Microsoft OLE DB Provider for AS/400
and VSAM
http://support.microsoft.com/?id=219077
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://support.microsoft.com/?id=218590
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:016701c35218$f63188c0$a501280a@.phx.gbl...
> Hello. Anyone know how what's needed to connect to an
> AS/400 from SQL Server via a Linked Server? Any special
> Provider softwre need to be in place? Any references on
> this would help. THanks a lot... Bruce|||Excellent info Dinesh. I'll check it out... THanks, Bruce
>--Original Message--
>Bruce,
>Try the MS Host Integration Server Administration
Client .What you should be
>installing is Microsoft ODBC Driver for DB2.
>Refer
>INF: Configuring Data Sources for the Microsoft OLE DB
Provider for AS/400
>and VSAM
>http://support.microsoft.com/?id=219077
>INF: Configuring Data Sources for the Microsoft OLE DB
Provider for DB2
>http://support.microsoft.com/?id=218590
>
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
>news:016701c35218$f63188c0$a501280a@.phx.gbl...
>> Hello. Anyone know how what's needed to connect to an
>> AS/400 from SQL Server via a Linked Server? Any special
>> Provider softwre need to be in place? Any references on
>> this would help. THanks a lot... Bruce
>
>.
>