Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2009

    Unanswered: SQL to DB2 Connection

    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:

    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.
    Last edited by Athers; 09-30-09 at 05:10.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts