Solved

Connection Probs from ASP to DB2

Posted on 2003-11-13
4
1,556 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
  • 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 100 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

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…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 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