471,075 Members | 754 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

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.SQLTABLES' (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..............

Aug 9 '06 #1
2 19262

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.SQLTABLES' (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>DB2 connect to dbname
c:\SQLLIB\bnd>DB2 bind @db2ubind.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind @db2cli.lst blocking all grant public
c:\SQLLIB\bnd>DB2 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/infoce...G_ITM61168.htm
Regards.....
Kamal.................

Aug 9 '06 #2
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.SQLTABLES' (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>DB2 connect to dbname
c:\SQLLIB\bnd>DB2 bind @db2ubind.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind @db2cli.lst blocking all grant public
c:\SQLLIB\bnd>DB2 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
Aug 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Jean-Marc Blaise | last post: by
3 posts views Thread by Jason Gyetko | last post: by
1 post views Thread by xf wang via DBMonster.com | last post: by
2 posts views Thread by Richard | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.