Solved

Connection Probs from ASP to DB2

Posted on 2003-11-13
4
1,549 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
ASP VB... 7 92
Creating TABS in ASP Classic NOT using DIV 22 57
Summernote and form validation 10 36
Error viewing ASP page 12 65
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now