I'm a windows programmer tryng to establish a data connection to a DB2 instance on an IBM i5 series machine. I talked to the IBM support center, and followed the guidelines by installing the required iSeries ODBC drive and accompanying Visual Stuido 2005 Add-Ins as detailed in the following reference doc:
But - when I try to establish a connection using the server IP address and database name - I keep getting the following connection error message:
Error opening connectionERROR  [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "192.168.14.23". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001
According to my IT guys, there is no firewall blocking and all ports should be open to receive. How can I check the actual connection is working/listenting on TCP/IP as well as on sockets? From the error - it seems as though the DB2 instance on the i5 series is not listening on TCP/IP and needs to be. Any ideas on how I can get this connection to work?
thanks in advance for any help with this.