Tuesday, March 27, 2012

DB2 OLEdb for linked server on SQL 2005 Express

Hi!
We use a SQL Server 2005 Express to link some other SQL Servers and
some Oracle servers together, to simplify our work.
Now I wanted to link in a IBM DB2 running on a AS400.
I downloaded the DB2OLEDB driver from Microsoft:
Microsoft OLEDB Provider for DB2 (DB2OLEDB.exe)
from the "Feature Pack for Microsoft SQL Server 2005"
http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en
But that only works with the Enterprise or Developer edition.
Is there any DB2OLEDB driver for SQL 2005 Express?
Marco Dieckhoff
GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys
On 2007-07-27, JPD <nospam@.nospamplease.com> wrote:
> Hi Marco,
> You're not the first person to hit this problem. Unfortunately there is
> no way that you can use an MS DB2 driver with anything other than these
> editions. You're only option is to download IBM's driver.
Thanks for the advice.
I got it earlier from the german sqlserver group, and spend a good
part of the morning searching for the IBM driver.
Can anyone give me a link?
Marco Dieckhoff
GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys

No comments:

Post a Comment