Solved

CONNECTION ERRORS

Posted on 2003-11-13
5
8,607 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
  • 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 125 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 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

12 Experts available now in Live!

Get 1:1 Help Now