Protocol Specific Error Code S 10061
Contents |
connecting Controller application server to DB2 database server Technote (troubleshooting) Problem(Abstract) Administrator is trying to test communication between sql30081n a communication error has been detected. sqlstate=08001 the Controller application server and the DB2 database server. For example, administrator sql30081n a communication error has been detected communication protocol being used tcp ip opens a command prompt (D:\Program Files\IBM\SQLLIB\BIN) and runs a command similar to: db2 connect to
Protocol Specific Error Code(s): "*", "*", "0". Sqlstate=08001
Communication Function Detecting The Error: "selectforconnecttimeout"
error was detected: "
check out the FAQ by clicking the link above. You may have to register before you can post: click http://www.dbforums.com/showthread.php?337623-IBM-CLI-Driver-SQL30081N the register link above to proceed. To start viewing messages, select http://stackoverflow.com/questions/36443896/db2-odbc-connection-protocol-specific-error-code-10061 the forum that you want to visit from the selection below. Results 1 to 14 of 14 Thread: [IBM][CLI Driver] SQL30081N Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch protocol specific to Threaded Mode 03-29-02,04:13 #1 msalvador View Profile View Forum Posts Registered User Join Date Mar 2002 Posts 2 Unanswered: [IBM][CLI Driver] SQL30081N Microsoft OLE DB Provider for ODBC Drivers error '80004005' [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 protocol specific error detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001 /selfscan/sswadmin/menus/exec/cmsea.asp, line 1908 This error appear when i try to open a connection. But what does it means Reply With Quote 04-02-02,13:47 #2 ljrong View Profile View Forum Posts Registered User Join Date Jan 2002 Location USA Posts 53 you must use Db2 update dbm cfg using svcename service_name to setup your correct servicename. Reply With Quote 02-04-03,15:27 #3 darrentk View Profile View Forum Posts Registered User Join Date Feb 2003 Posts 5 What did you update the service name to, or where do i find that out? Originally posted by ljrong you must use Db2 update dbm cfg using svcename service_name to setup your correct servicename. Reply With Quote 02-05-03,05:39 #4 sathyaram_s View Profile View Forum Posts Visit Homepage Super Moderator Join Date Aug 2001 Location UK Posts 4,650 You will have to define a service/port in /etc/services file ... Eg ... db2cdb2inst1 50000 db2idb2inst1 50001 and th
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up DB2 - ODBC Connection protocol specific error code 10061 up vote 1 down vote favorite I installed DB2 FP 10.1 32-bit ODBC Driver on Windows 7 (64-bit) from the following URL https://www-304.ibm.com/support/docview.wss?uid=swg21418043 I created a 'System DSN' and configured the following parameters Hostname xxxxxx2x (DB2 server running on UNIX) Port 5xxxx (Port is on state 'LISTENING') Database dxxx DBAlias dxxx Protocol TCP / IP And when I 'Connect' (Test Connection) from ODBC, I get the following error SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected. Protocol specific error code(s) 10061. sqlstate=08001 To me settings are correct, not sure what am I missing db2 odbc database-administration share|improve this question asked Apr 6 at 7:09 Sathish Kumar 1481112 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote How did you create the System DSN? Windows 7 64-bit will create the DSN under the 64-bit ODBC Data Source Admin by default. I think I've had better luck creating it under the 32-bit version, which can be found at C:\Windows\SysWOW64\odbcad32.exe. share|improve this answer answered Apr 6 at 17:17 David 907 Yes, I created it via odbcad32.exe –Sathish Kumar Apr 8 at 14:45 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged db2 odbc database-administration or ask your own question. asked 6 months ago viewed 101 times active 6 months ago Blog Stack Ove