Topic
2 replies Latest Post - ‏2007-01-09T01:05:37Z by Jean_Anderson
SystemAdmin
SystemAdmin
1525 Posts
ACCEPTED ANSWER

Pinned topic Set up ODBC system DSN on remote via IBM DB2 Run-Time Client Lite

‏2007-01-09T00:37:55Z |
I am stuck with creating a ODBC DSN to connect to a Derby network database server via TCP/IP. I received the following error from 'CLI/ODBC Settings' GUI after clicked on connect button:

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.60.51".
Communication function detected the error: "connect". Protocol specific error code(s) :"10061",
"", "". SQLSTATE=08001.

Seems like some security permissions were not setup right. Could anyone shed some light?

Thanks much.
Updated on 2007-01-09T01:05:37Z at 2007-01-09T01:05:37Z by Jean_Anderson
  • Jean_Anderson
    Jean_Anderson
    179 Posts
    ACCEPTED ANSWER

    Re: Set up ODBC system DSN on remote via IBM DB2 Run-Time Client Lite

    ‏2007-01-09T00:46:41Z  in response to SystemAdmin
    I did a search for SQL30081N on this forum and found this lengthy thread:

    http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?message=13778024&cat=19&thread=103691&treeDisplayType=threadmode1&forum=370#13778024

    There's some helpful info in some of Stan's followup posts. Please let me know if anything there helps isolate your problem.

    regards,

    -jean
    • Jean_Anderson
      Jean_Anderson
      179 Posts
      ACCEPTED ANSWER

      Re: Set up ODBC system DSN on remote via IBM DB2 Run-Time Client Lite

      ‏2007-01-09T01:05:37Z  in response to Jean_Anderson
      Also, a search for "SQL30081N" in the DB2 for Linux, UNIX, and Windows forum at http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=291&cat=19 has lots of hits that might help you isolate the problem.

      Please let me know how it works out. If you still can't get it working, please post more details about your configuration (the specific DB2 ODBC release you're using, what GUI you're using, the specific commands you use to catalog the derby database, etc.)

      regards,

      -jean