Connection Probs from ASP to DB2

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.
LVL 17
k_murli_krishnaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brad Dobyns, CSMScrumMasterCommented:
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
Brad Dobyns, CSMScrumMasterCommented:
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
Brad Dobyns, CSMScrumMasterCommented:
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
Brad Dobyns, CSMScrumMasterCommented:
This may help you as its where I get all my information:

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

Brad
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.