SQLSTATE 38553

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Gladiator
    #1

    SQLSTATE 38553


    Hai everyone....

    When i am trying to access the DB2 from Crystal reports
    10.0 in windows Operating system it is giving me the following
    Error.......... ......

    "Query Engine error: [IBM] [CLI Driver][DB2/NT] SQL0443N Routine
    "SYSIBM.SQLTABL ES' (specific name "TABLES") has returned an error
    SQLSTATE with diagnostic text. "SYSIBM:CLI :-805", SQLSTATE=38553"

    Can anyone pls help me out how to resolve the issue ...........

    Regards
    Kamal.......... ....

    Tags: error sqlstate, sqlstate, sqlstate: 38553
    • Gladiator
      #2
      Re: SQLSTATE 38553


      Gladiator wrote:
      Hai everyone....
      >
      When i am trying to access the DB2 from Crystal reports
      10.0 in windows Operating system it is giving me the following
      Error.......... ......
      >
      "Query Engine error: [IBM] [CLI Driver][DB2/NT] SQL0443N Routine
      "SYSIBM.SQLTABL ES' (specific name "TABLES") has returned an error
      SQLSTATE with diagnostic text. "SYSIBM:CLI :-805", SQLSTATE=38553"
      >
      Can anyone pls help me out how to resolve the issue ...........
      >
      Regards
      Kamal.......... ...

      Hey .... Problem Solved....\


      I used the Following commands .......

      c:\SQLLIB\bnd>D B2 connect to dbname
      c:\SQLLIB\bnd>D B2 bind @db2ubind.lst blocking all grant public
      c:\SQLLIB\bnd>D B2 bind @db2cli.lst blocking all grant public
      c:\SQLLIB\bnd>D B2 bind db2schema.bnd blocking all grant public

      Its working fine........... That was the problem with fixpack
      upgradation ......

      For more info .........

      http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp?topic=/com.ibm.itm.doc/PDG_ITM61168.htm



      Regards.....
      Kamal.......... .......

        Comment

        • Knut Stolze
          #3
          Re: SQLSTATE 38553

          Gladiator wrote:
          >
          Gladiator wrote:
          >Hai everyone....
          >>
          > When i am trying to access the DB2 from Crystal reports
          >10.0 in windows Operating system it is giving me the following
          >Error......... .......
          >>
          >"Query Engine error: [IBM] [CLI Driver][DB2/NT] SQL0443N Routine
          >"SYSIBM.SQLTAB LES' (specific name "TABLES") has returned an error
          >SQLSTATE with diagnostic text. "SYSIBM:CLI :-805", SQLSTATE=38553"
          >>
          >Can anyone pls help me out how to resolve the issue ...........
          -805 is a timestamp conflict between application and packages.
          c:\SQLLIB\bnd>D B2 connect to dbname
          c:\SQLLIB\bnd>D B2 bind @db2ubind.lst blocking all grant public
          c:\SQLLIB\bnd>D B2 bind @db2cli.lst blocking all grant public
          c:\SQLLIB\bnd>D B2 bind db2schema.bnd blocking all grant public
          >
          Its working fine........... That was the problem with fixpack
          upgradation ......
          Apparently, you skipped the README. ;-)

          --
          Knut Stolze
          DB2 Information Integration Development
          IBM Germany

            Comment

            Previous template Next
            Working...