Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issue with connection to DB2 source connection manager Expand / Collapse
Author
Message
Posted Monday, June 10, 2013 12:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, September 28, 2014 12:47 PM
Points: 141, Visits: 282
Hello All,


In my package source table is exist in DB2 and target will be Oracle db, just a simple table to table copy,


when i try to configure connection manager for source, and test i have the below issue, does anybody have idea why i am getting this, and what could i do here to resolve this please?


Provider: Native OLEDB\IBM OLEDB Provider for DB2

OLEDB Provider: IBM OLE DB Provider for DB2

Server or file name: gsk_Wherehouse

Location: Gsk_Collegewille.wh.clb.com:32000




TITLE: Connection Manager
------------------------------

Test connection failed because of an error in initializing provider. SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "198.777.66.22". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001




Thank you

Milan,
Post #1461706
Posted Monday, June 10, 2013 10:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, September 28, 2014 12:47 PM
Points: 141, Visits: 282
hello all pleasse share any ideas


thank you in advance
Post #1461855
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse