|
Home > Archive > MS SQL Server > July 2005 > DB2 Linked Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Tinchos 2005-07-27, 8:23 pm |
| 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\) 2005-07-27, 8:23 pm |
| 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
| |
| Zarko Jovanovic 2005-07-28, 3:23 am |
| 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
|
|
|
|
|