-
Title
"SQL30081N A communication error has been detected" error when connecting to DB2 database server -
Description
"SQL30081N A communication error has been detected" error when connecting to DB2 database server -
Resolution
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.53.66". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
[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.53.66". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001- [Microsoft][ODBC Driver Manager] Invalid connection string attribute [Microsoft][ODBC Driver Manager] Invalid connection string attribute
Solution:
Try connecting to the DB2 server using the command "telnet".
- If there is an error "Connecting To ...Could not open connection to the host, on port 50000: Connect failed" then it is an indication that there is a firewall blocking communication.
- Instead, if everything is working correctly, then the screen *should* change instantly to black.
Example:
Assuming that the DB2 server is running on the default TCP port (50000) then the command would be:
telnet <DB2_servername> 50000
Resolving the issue:
Reconfigure the Windows firewall (running on the DB2 server) to allow communication in via the DB2 TCP port (default = 50000)
Steps:
1. Logon to the DB2 server as an administrator
2. Launch "Control Panel\System and Security\Windows Firewall"
3. Click "Advanced settings":
4. Click "New Rule"
5. Choose "Port":
6. Choose TCP and 50000 (if necessary modify this value to match your specific settings)
7. Choose "Allow the Connection":
8. Ensure that all locations are ticked:
9. Name the rule appropriately
10. Click ' Finish' and test.
