Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connection Probs from ASP to DB2

Posted on 2003-11-13
4
Medium Priority
?
1,584 Views
Last Modified: 2012-05-04
While connecting from ASP via ODBC DSN with Named Pipes to DB2 database 7.2 on Win NT 4 workstation,  we got the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][CLI Driver] SQL0902C A system error (reason code = "-20475") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005

While connecting with TCP/IP, we got this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][CLI Driver] SQL1097N The node name was not found in the node directory. SQLSTATE=42720

Can you suggest solutions to the above 2 errors.
0
Comment
Question by:k_murli_krishna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
4 Comments
 
LVL 7

Expert Comment

by:Brad Dobyns, CSM
ID: 9740951
If this is DB2 for OS/390 then this message probably indicates you have to rebind your program. Look at this:

 - 902 POINTER TO THE ESSENTIAL CONTROL BLOCK (CT/RDA) HAS VALUE 0, REBIND REQUIRED

Explanation: Pointer to the essential control block, either the CT or the RDA is zeroes. This precludes the successful execution of the current SQL statement, as well as any subsequent SQL statements.

System Action: The statement cannot be executed. The application program is not permitted to issue additional SQL statements. For example, a recovery routine associated with the application program may not issue additional SQL statements.

Programmer Response: Rebind the failing application program and try again. If the problem persists, examine your DBRM and make sure it matches your program.

Let me check on the other one.

Brad
0
 
LVL 7

Expert Comment

by:Brad Dobyns, CSM
ID: 9741039
Here is what I found out about the other:

SQL1097N - The node name was not found in the node directory.

Explanation: Either the node name listed in the database directory for a remote database or the node name specified on an attach command was not cataloged in the node directory.

The command cannot be processed.

User Response: Verify that the node name listed in the database directory or as the object of the attach command is cataloged in the node directory. If the node is not listed in the node directory, submit a CATALOG NODE command.

sqlstate: 42720

Brad
0
 
LVL 7

Expert Comment

by:Brad Dobyns, CSM
ID: 9741077
Sorry about the other one. I just realized that you are not using OS/390. Here is what the error means:

SQL0902C A system error (reason code = "<reason-code>") occurred. Subsequent SQL statements cannot be processed.  

Explanation: A system error occurred.

User Response: Record the message number (SQLCODE) and reason code in the message.

If trace was active, invoke the Independent Trace Facility at the operating system command prompt. Refer to the Independent Trace Facility in the Troubleshooting Guide for information on how to use this facility. Then contact your technical service representative with the following information:

Problem description
SQLCODE and embedded reason code
SQLCA contents if possible
Trace file if possible.

sqlstate: 58005

Brad
0
 
LVL 7

Accepted Solution

by:
Brad Dobyns, CSM earned 400 total points
ID: 9741090
This may help you as its where I get all my information:

https://aurora.vcu.edu/db2help/db2m0/frame3.htm#index

Brad
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question