473,382 Members | 1,363 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001

7
I tried to connect DB2 (Sitting in Unix server at my client location) using Db2 connect V8. I am getting the following error message. I tried all the possible options BUt the error is same.. See each type belpw

Standard connection failed.
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "". Communication function detecting the error:
"connect". Protocol specific error code(s): "10060", "*", "*".
SQLSTATE=08001
CLI connection failed.
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
OLEDB connection failed.
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
JDBC connection failed.
[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: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
ADO connection failed.
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
Jun 19 '07 #1

✓ answered by hitendrap

If u are getting: SQL30081N Protocol specific error code(s): "10065", "*", "*". SQLSTATE=08001

If you are using Linux server , turn off your firewall service & check if you can connect to database remotely through

client
to stop firewall type this command on bash : $ etc/init.d/iptables stop

If now you can connect remotely thru client then
turn OFF firewall service from all run levels
before that check

$ chkconfig --list iptables

if they are ON @ runlevels 2,3,4,5 then

$ chkconfig --levels 2345 iptables off


Regards.
Hitendra

4 48620
Is this problem fixed?
I also encounter this on my platform SUSE10 .Hope someone will help
Apr 17 '09 #2
Folks,
Here is the list of some SQL30081N TCP/IP communication protocol errors and recommended action plans associated with them.
http://www-01.ibm.com/support/docvie...id=swg21164785

Cheers !
Thanks,
Shashank Kharche, IBM.
DB2 for Linux, Unix & Windows -Information Management Software
Apr 18 '09 #3
Thanks, I will check in to it.
Apr 20 '09 #4
If u are getting: SQL30081N Protocol specific error code(s): "10065", "*", "*". SQLSTATE=08001

If you are using Linux server , turn off your firewall service & check if you can connect to database remotely through

client
to stop firewall type this command on bash : $ etc/init.d/iptables stop

If now you can connect remotely thru client then
turn OFF firewall service from all run levels
before that check

$ chkconfig --list iptables

if they are ON @ runlevels 2,3,4,5 then

$ chkconfig --levels 2345 iptables off


Regards.
Hitendra
Sep 24 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: dance | last post by:
My Apologies for my ineptitude on posting, this is all new to me...........but I'll get it.... I'm using Windows 2000 Version 5.0 with Service pack 4 I installed the free version of Oracle...
8
by: Shane Groff | last post by:
I know this is a recurring discussion (I've spent the last 3 days reading through threads on the topic), but I feel compelled to start it up again. After reading through the existing threads, I...
9
by: Alejandro Forero Cuervo | last post by:
Hello. I'm new to PostgreSQL and I'm using it for some project. I am currently creating an entity engine that provides a web interface, which is oriented towards end users, to...
1
by: Grant Allen | last post by:
Hi all, I've been hunting around the techdocs site looking for a comprehensive listof error codes for certain errors. The only thing I can find is a list ofa few (textual) errors - nothing that...
2
by: Madhu | last post by:
Hello All, I am getting the below error message when I am trying to connect from client to remote database server installed on Linux. DB2 UDB ESE database is running on a trail version on Linux...
0
by: HKSHK | last post by:
This list compares the error codes used in VB.NET 2003 with those used in VB6. Error Codes: ============ 3: This Error number is obsolete and no longer used. (Formerly: Return without GoSub)...
6
by: tycoonajayverma | last post by:
Hi, Can some one help me out for these following errors 24-OCT-2006 11:52:03 * (CONNECT_DATA=(SID=pro1)(CID=(PROGRAM=)(HOST=report2)(USER=crystal))) *...
2
by: Brent Halsey | last post by:
I am using the ibm_db2 PECL drive in PHP for connecting to or DB2 database. I created a persistent connection and things seemed to work fine at first. However, after a few tests / connections, I...
13
by: mike3 | last post by:
Hi. (crossposted because the program is in C++ and some C++-related elements are discussed, hence comp.lang.c++, plus general program design questions are asked, hence comp.programming.) I'm...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.