Attempt to connect failed. Errors according to port on connection string.
yuan
Hi, I'm having problems to connect to an iSeries DB2.
When I choose 8471 port to connect I have a timeout error and can't connect.
{ [Error: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "10.100.0.25". Communication function detecting the error: "selectForRecvTimeout". Protocol specific error code(s): "115", "", "". SQLSTATE=08001]
errors: [],
error: '[node-odbc] SQL_ERROR',
message: '[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "10.100.0.25". Communication function detecting the error: "selectForRecvTimeout". Protocol specific error code(s): "115", "", "". SQLSTATE=08001\n', state: '08001' }
When I choose 446 port I have and licensing error:
{ [Error: [IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968]
errors: [],
error: '[node-odbc] SQL_ERROR',
message: '[IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968\n', state: '42968' }
Wich one it's the correct port (or neither) and how to solved (if it's possible, 'cause as far as I know, licensing error I need a license, that I do not have) ?
Thx for your help.
Saba Kauser
The communication error is because you are making a connection through a wrong port. The connection should be attempted at the port the DB2 server is listening to. But it looks like that the Iseries server does not seem to listen on 8471. I think 446 is the correct port and for connection to succeed, you should either have a client or server side license.
For more information on server based licensing, refer : http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.licensing.doc/doc/t0057375.html?cp=SSEPGG_10.5.0%2F1-1-2-1
Using client side license requires you to have a valid db2 connect server as gateway.
Using CLI driver, license requirements are documented here:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0024162.html?lang=en