Solved

CONNECTION ERRORS

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

632 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