Solved

CONNECTION ERRORS

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

810 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