I am having trouble connecting to a DB2 database from SQL server 2008/Visual Studio. It is DB2 Express v220.127.116.11 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:
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.