Data Access Worldwide Knowledge Base
Article Text
PROBLEM:
My client is Winbdows and my server sits on Linux. I was able to add the Linux box system and databases to my Windows client but I am getting error SQL30081N when trying to open my database in Control Center.
SOLUTION:
Thew full error message is:
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "$myIP". Communication function
detecting the error: "connect". Protocol specific error code(s): "111", "*",
"*". SQLSTATE=08001
One of the reasons why this error may occur is that the server name (the system) cannot be found. You should add the server IP Address to the hosts file of your Windows client machine so that the DB2 client can find the host name you specify at all times.
The location of the hosts file varies, but it can normally be found under C:\Windows\system32\drivers\etc.
Also, make sure port 50000 is open on the server -- that's the default port used by DB2 and your client should be able to connect to the server through that.
Contributed By:
Marcia Booth
Company: Data Access Worldwide
Web Site: http://www.dataaccess.com
Web Links Related to this Article
IBM - Received an SQL30081N communication error when trying to connect to server.
URL=http://www-1.ibm.com/support/docview.wss?rs=0&q1=SQL30081N&uid=swg21079102&loc=en_US&cs=utf-8&cc=us&lang=en
IBM - SQL30081N TCPIP communication error
URL=http://www-1.ibm.com/support/docview.wss?rs=0&q1=SQL30081N&uid=swg21164785&loc=en_US&cs=utf-8&cc=us&lang=en
SQL30081N A communication error has been detected
URL=http://www.thescripts.com/forum/thread185462.html
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
| The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply. |