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

x
?
Solved

CONNECTION ERRORS

Posted on 2003-11-13
5
Medium Priority
?
8,745 Views
Last Modified: 2012-06-22
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. I used to work with DB2COMM which is a DB2 environment variable. When I give set command at DOS prompt BIN directory, this is not in the list of name value pairs.

But in registry, we have DB2COMM=NETBIOS,TCPIP,NPIPE. In system environment, we have variable DB2COMM=C:\Program Files\sqllib. It should be DB2HOME instead, isn't it & shall I set DB2COMM here as I found in registry. I checked database manager configuration and database configuration parameters and DB2COMM is not there.

How can we set DB2COMM for server, instance, database, connection & transaction and same is my doubt regarding setting instance.
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
5 Comments
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 9745669
What we have to do to work along with 3 instances i.e. DB2, DB2CTLSV and one more user created. Please look at this 3rd error as well:

SQL1097N The node name was not found in the node directory.
sqlcode: -1097
sqlstate: 42720

I will give more points to all deserving.
0
 
LVL 9

Accepted Solution

by:
mglxxx earned 375 total points
ID: 9750361
Just a hunch: did you check the setting of the DB2INSTANCE environment variable?
If you don't want to fiddle around with the environment variable, another option would be to
catalog the other instances as nodes in the default instance (DB2 on a standard installation).
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 9752961
mglxxx, this is nice & i will work on it. You did not comment on the 2 errors from ASP via ODBC to DB2 & nothing about DB2COMM. Please look at my other very systematic question with 250 points i.e. CONNECTION PROBLEMS.
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 9753038
Are the connection problems due to db2, ODBC or ASP.
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 9764659
My problem is solved & I deleted the other question. I cataloged the node with all possible details at client end. Thank you.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

705 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