469,889 Members | 1,265 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,889 developers. It's quick & easy.

Can connect to one DB but not another on same server??

Windows XP connected via DSL over a VPN to an AIX server
DB2/6000 8.2.3
Using IBM DB2 ODBC Driver

I can connect fine to a specific DB via an AIX box and a person in the
next cubicle connected the same way as I am can access the database.
Last week I connected fine but some network issues occurred since. I
now can connect to one DB but not another on the same server using the
the same user ID/password. I've had no issues connecting to either DB
for months.

I'm getting the error below:
SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "nnn.nnn.n.nn". Communication function
detecting the error: "connect". Protocol specific error code(s):
"10061", "*",
"*". SQLSTATE=08001

The IP address, nnn.nnn.n.nn, is my local laptop.

Obviously, the problem is local to my Windows client. Does anyone have
any ideas on what I might check?

Thanks, Jim D.

Jun 28 '06 #1
2 1884
I deleted and re-created the ODBC driver entry without any change in
result. I also get the same error when testing the connection via ODBC
or CLI in the Configuration Assistant.

Jim D.

Jun 28 '06 #2
I found my problem by comparing the working connection with the problem
DB using the Configuration Assistant. Curiously, the host name was my
local workstation. I changed this to the proper host name and
everything is fine. I have no idea how the host name got changed and,
as the incorect host name was a meaningless collection of letters that
came from the manufacturer, there's no way I could have made the change
manually.

Jim D.

Jun 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Jerry Orr | last post: by
reply views Thread by Clodoaldo Pinto | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.