Protocol Specific Error Code Sqlstate=08001
Contents |
connecting Controller application server to DB2 database server Technote (troubleshooting) Problem(Abstract) Administrator is trying to test communication between the Controller sql30081n a communication error has been detected. sqlstate=08001 application server and the DB2 database server. For example, administrator opens a
Protocol Specific Error Code(s) 10061 * * . Sqlstate=08001
command prompt (D:\Program Files\IBM\SQLLIB\BIN) and runs a command similar to: db2 connect to
Sql30081n Sqlstate=08001 Recv
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
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,623 IT Pros & Developers. It's quick & easy. https://bytes.com/topic/db2/answers/664733-protocol-specific-error-code-s-10060-sqlstate-08001-a Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001 P: 7 Pool I tried http://stackoverflow.com/questions/11347692/error-rror-08001-ibm-sql30081n-when-connecting-to-as400-iseries-from-nhibe 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 protocol specific 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 protocol specific error 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 Post Reply ✓ 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
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 Error RROR [08001] [IBM] SQL30081N when connecting to AS400 (iSeries) from NHibernate using C# up vote 3 down vote favorite I have absolutely no experience with AS400 DB2 so please forgive any glaring mistakes as I am learning as I go along. I have 2 boxes I can connect to running v5r3 or v4r3. and I am using NHibernate 3. However, when I try and connect I keep getting the following exception :- 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: "192.168.1.11". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001 Below is my NHibernate configuration file:-