Db2 Sql Error Code 10061
Contents |
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
Db2 Sql Error Code 811
Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Db2 Sql Error Code 204
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community db2 sql error code 206 of 4.7 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 https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.messages.sql.doc/doc/msql30081n.html 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: http://stackoverflow.com/questions/36443896/db2-odbc-connection-protocol-specific-error-code-10061 "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 1381111 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 88 times active 6 months ago Related 1Cannot create DB2 index, getting
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 http://stackoverflow.com/questions/11762206/net-application-cannot-connect-to-db2-database Stack Overflow the company Business Learn more about hiring developers or posting ads https://community.powerbi.com/t5/Integrations-with-Files-and/Error-when-trying-to-connect-to-IBM-DB2/td-p/10126 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 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up .net application cannot connect to DB2 DataBase up vote 4 down vote favorite db2 sql 1 ERROR [08001] [IBM] 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.66.180.30". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "", "". SQLSTATE=08001 .net db2 share|improve this question edited Dec 3 '12 at 13:52 AngocA 5,75621744 asked Aug 1 '12 at 15:10 Santiago Elvira Ramirez 1,043726 add a comment| 2 Answers db2 sql error 2 active oldest votes up vote 3 down vote accepted You have to download the driver directly from the IBM page ;) share|improve this answer answered Aug 1 '12 at 15:13 danielrvt 2,26542358 add a comment| up vote 1 down vote There are a number of reasons for this error, your db2 is started? oyou have configured the node, the runtime client is properly installed?, check out this link for more. share|improve this answer answered Aug 1 '12 at 15:20 Luis Specian 816 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 .net db2 or ask your own question. asked 4 years ago viewed 809 times active 3 years ago Linked 1 IBM DB2 Connection using VS2012 framework 4 Related 1Cannot create DB2 index, getting SQL30081N error1IBM.Data.DB2.DB2Exception: ERROR [08001] [IBM] SQL30081N A communication error has been detected.0DB2 ConnectionString error0Connecting to DB2 database1IBM DB2 Connection using VS2012 framework 41Connecting to iser
Give Feedback Webinars Blog Home Forums Ideas Events User Groups Community Blog Register · Sign In · Help Integrations with Files and Services Go To Forums Desktop Service Integrations with Files and Services Mobile Apps Developer Forums : Integrations with Files and Services : Error when trying to connect to IBM DB2 Reply Topic Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page « Message Listing « Previous Topic Next Topic » mckinzie Frequent Visitor Posts: 4 Registered: 11-06-2015 Error when trying to connect to IBM DB2 Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 11-13-2015 10:55 AM I'm getting an error when trying to connect to our IBM DB2 database. I removed the IP in the error below. Anyone have any ideas? I don't see anywhere to enter a port number if we need to.Details: "IBM DB2: ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "IP removed". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001
" Report Inappropriate Content Message 1 of 6 (1,003 Views) Labels: Need Help Reply 0 Kudos PowerBIGuy Member Posts: 118 Registered: 10-15-2015 Re: Error when trying to connect to IBM DB2 [Edited] Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 11-13-2015 11:33 AM - edited 11-13-2015 11:34 AM Have you tired using [servername]:[portnumber] as the server name? Business Intelligence Architect / Consultant Report Inappropriate Content Message 2 of 6 (992 Views) Reply 0 Kudos smoupre Occasional Contributor Posts: 2,617 Registered: 07-11-2015 Re: Error when trying to connect to IBM DB2 Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 11-13-2015 11:41 AM You could try [IP]:[Port] for the server entry. Hav