DB2 Linked Server

Hi List, anyone can help me?

I need to make a connection between SQL2000 SP3 and DB2 running on AS400.
When i try to make a Linked server i could not be able to see the ODBC
Driver for DB2.
What driver is needed to install the odbc support? is from MS?

Thanks

Hi

You need to get the DB2 ODBC/OLE DB driver from IBM and install it on your
SQL Server.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Tinchos" <Tinchos@discussions.microsoft.com> wrote in message
news:A9564915-2DC7-431F-B1C3- BC4565CC5DCB@microso
ft.com...
> Hi List, anyone can help me?
>
> I need to make a connection between SQL2000 SP3 and DB2 running on AS400.
> When i try to make a Linked server i could not be able to see the ODBC
> Driver for DB2.
> What driver is needed to install the odbc support? is from MS?
>
> Thanks

Mike Epprecht (SQL MVP)  wrote:
> Hi
>
> You need to get the DB2 ODBC/OLE DB driver from IBM and install it on your
> SQL Server.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Tinchos" <Tinchos@discussions.microsoft.com> wrote in message
> news:A9564915-2DC7-431F-B1C3- BC4565CC5DCB@microso
ft.com...
> 
>
>
>
and when you do, please tell us how did you set the connection string