Hi all,

I am having trouble connecting to a DB2 database from SQL server 2008/Visual Studio. It is DB2 Express v9.1.200.166 on a Windows server.

I have downloaded the Microsoft db2 OLE DB driver, but receive an error message when trying to configure it using the data import wizard in SSMS, or when trying to create a connection manager in VS2008.

Error when testing connection:

Test connection failed because of an error in initializing the provider. - The parameter is incorrect.

This is my error when trying to configure a package:

Connecting...
Package creation failed:
A TCPIP socket error has occured (10061): No connection could be made because the target machine actively refused it.
SQLSTATE: 08S01, SQLCODE: 10061

I have run netstat and think i'm using the correct port db2 is listening on. I've also turned off the firewall for now and enabled TCP/IP.

Can anyone offer any advice?

Thanks in advance.