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/keysHi 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.
Jonathan
Marco Dieckhoff wrote:
> 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?
>|||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|||Hi Marco,
I found a bunch of drivers but not the OLEDB one. I would suggest you
put in a post on the IBM newsgroups.
Jonathan
Marco Dieckhoff wrote:
> 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?
>