Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Unanswered: SQL0805N Package "NULLID.SQLLD005" was not found

    Hi,
    I have got this error many time.
    "Error Exception : System.Data.OleDb.OleDbException: [DB2/NT] SQL0805N Package "NULLID.SQLLD005" was not found. SQLSTATE=51002
    CLI0129E No more handles. SQLSTATE=HY014"

    The number of "NULLID.SQLLD???" is sometime changed to 003, 004 or 007.
    I have got it since we move to new database server which is installed db2 same version.
    My DBA tried to re-bind but I have still got it.IBM DB2 support said it hard to find out.
    How could the application developer like me solve this?
    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Quote Originally Posted by Srivara
    Hi,
    I have got this error many time.
    "
    CLI0129E No more handles. "

    How could the application developer like me solve this?
    Thanks.
    Check this out...

    CLI0129E No more handles.
    Explanation: A call was made to SQLAllocEnv, SQLAllocConnect, or SQLAllocStmt but no more handles are available in the driver.
    User Response: Call SQLFreeEnv, SQLFreeConnect, or SQLFreeStmt to free up some handles which are no longer being used in the application.

    HTH.

  3. #3
    Join Date
    Jan 2004
    Posts
    49
    Try to bind the utilities in the client as like below,

    db2 "bind @db2ubind.lst blocking all grant public"
    db2 "bind @db2cli.lst blocking all grant public"

    With Regards

    Bala

  4. #4
    Join Date
    Mar 2005
    Posts
    4
    I have met the same problem before. The solution is what Bala said.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •