Tuesday, March 27, 2012

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?
ThanksHi
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@.microsoft.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@.microsoft.com...
>
>
>
and when you do, please tell us how did you set the connection string

No comments:

Post a Comment