473,218 Members | 1,839 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,218 software developers and data experts.

Connecting to DB2

I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
getting the following message

ERROR [08001] [IBM] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected: "10.100.1.69".
Communication function detecting the error: "connect". Protocol specific
error code(s): "10061", "*", "*". SQLSTATE=08001

When I use DB2 control center or setup a ODBC connection it works fine
Here is my connection string:

Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password

Does anyone have a solution for this problem, or how to trouble shoot this?
Thank You
Peter
Feb 2 '06 #1
14 11454
Peter,

By chance, are you running this in ASP.NET? If so, ASP.NET runs under a
local user ASPNET by default that does not have network access. If your DB
is on another machine, this could definitely be a problem.

The same is true for a program you might have loaded from the internet
or your network (assuming it is not from the machine that the DB is on).

Can you give a little more information about the error?

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Peter" <pc*****@nospam.nospam> wrote in message
news:eo**************@TK2MSFTNGP14.phx.gbl...
I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
getting the following message

ERROR [08001] [IBM] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being
used: "SOCKETS". Location where the error was detected: "10.100.1.69".
Communication function detecting the error: "connect". Protocol specific
error code(s): "10061", "*", "*". SQLSTATE=08001

When I use DB2 control center or setup a ODBC connection it works fine
Here is my connection string:

Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password

Does anyone have a solution for this problem, or how to trouble shoot
this?
Thank You
Peter

Feb 2 '06 #2
This has nothing to do with network access, integrated security is not used
here, the connection string contains explicit user credentials.

Willy.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:O$**************@TK2MSFTNGP12.phx.gbl...
| Peter,
|
| By chance, are you running this in ASP.NET? If so, ASP.NET runs under
a
| local user ASPNET by default that does not have network access. If your
DB
| is on another machine, this could definitely be a problem.
|
| The same is true for a program you might have loaded from the internet
| or your network (assuming it is not from the machine that the DB is on).
|
| Can you give a little more information about the error?
|
| Hope this helps.
|
|
| --
| - Nicholas Paldino [.NET/C# MVP]
| - mv*@spam.guard.caspershouse.com
|
| "Peter" <pc*****@nospam.nospam> wrote in message
| news:eo**************@TK2MSFTNGP14.phx.gbl...
| >I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
| >getting the following message
| >
| > ERROR [08001] [IBM] SQL30081N A communication error has been detected.
| > Communication protocol being used: "TCP/IP". Communication API being
| > used: "SOCKETS". Location where the error was detected: "10.100.1.69".
| > Communication function detecting the error: "connect". Protocol
specific
| > error code(s): "10061", "*", "*". SQLSTATE=08001
| >
| > When I use DB2 control center or setup a ODBC connection it works fine
| > Here is my connection string:
| >
| > Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
| >
| > Does anyone have a solution for this problem, or how to trouble shoot
| > this?
| >
| >
| > Thank You
| >
| >
| > Peter
| >
| >
|
|
Feb 2 '06 #3

"Peter" <pc*****@nospam.nospam> wrote in message
news:eo**************@TK2MSFTNGP14.phx.gbl...
|I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
| getting the following message
|
| ERROR [08001] [IBM] SQL30081N A communication error has been detected.
| Communication protocol being used: "TCP/IP". Communication API being
used:
| "SOCKETS". Location where the error was detected: "10.100.1.69".
| Communication function detecting the error: "connect". Protocol specific
| error code(s): "10061", "*", "*". SQLSTATE=08001
|
| When I use DB2 control center or setup a ODBC connection it works fine
| Here is my connection string:
|
| Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
|
| Does anyone have a solution for this problem, or how to trouble shoot
this?
|
|
| Thank You
|
|
| Peter
|
|

All I know is that 10061 means "connection refused", don't know what
SQLState 08001 means though.

What kind of client application is this? .NET or other?
Willy.
Feb 2 '06 #4

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:%2***************@TK2MSFTNGP09.phx.gbl...
This has nothing to do with network access, integrated security is not
used
here, the connection string contains explicit user credentials.

Willy.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
in
message news:O$**************@TK2MSFTNGP12.phx.gbl...
| Peter,
|
| By chance, are you running this in ASP.NET? If so, ASP.NET runs
under
a
| local user ASPNET by default that does not have network access. If your
DB
| is on another machine, this could definitely be a problem.
|
| The same is true for a program you might have loaded from the
internet
| or your network (assuming it is not from the machine that the DB is on).
|
| Can you give a little more information about the error?
|
| Hope this helps.
|
|
| --
| - Nicholas Paldino [.NET/C# MVP]
| - mv*@spam.guard.caspershouse.com
|
| "Peter" <pc*****@nospam.nospam> wrote in message
| news:eo**************@TK2MSFTNGP14.phx.gbl...
| >I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
| >getting the following message
| >
| > ERROR [08001] [IBM] SQL30081N A communication error has been
detected.
| > Communication protocol being used: "TCP/IP". Communication API being
| > used: "SOCKETS". Location where the error was detected:
"10.100.1.69".
| > Communication function detecting the error: "connect". Protocol
specific
| > error code(s): "10061", "*", "*". SQLSTATE=08001
| >
| > When I use DB2 control center or setup a ODBC connection it works fine
| > Here is my connection string:
| >
| > Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
| >
| > Does anyone have a solution for this problem, or how to trouble shoot
| > this?
| >
| >
| > Thank You
| >
| >
| > Peter
| >
| >
|
|


This is a console application; using same credentials as my ODBC connection
and ODBC works but IBM DB2 provider does not.
Database is on a different machine, database is running on Linux, but I have
no problems connecting to it with the ODBC driver within the same
application.

Feb 2 '06 #5
Could you try to add the "Driver" property in the ConnectionString?

Willy.

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
|
| "Peter" <pc*****@nospam.nospam> wrote in message
| news:eo**************@TK2MSFTNGP14.phx.gbl...
||I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
|| getting the following message
||
|| ERROR [08001] [IBM] SQL30081N A communication error has been detected.
|| Communication protocol being used: "TCP/IP". Communication API being
| used:
|| "SOCKETS". Location where the error was detected: "10.100.1.69".
|| Communication function detecting the error: "connect". Protocol specific
|| error code(s): "10061", "*", "*". SQLSTATE=08001
||
|| When I use DB2 control center or setup a ODBC connection it works fine
|| Here is my connection string:
||
|| Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
||
|| Does anyone have a solution for this problem, or how to trouble shoot
| this?
||
||
|| Thank You
||
||
|| Peter
||
||
|
| All I know is that 10061 means "connection refused", don't know what
| SQLState 08001 means though.
|
| What kind of client application is this? .NET or other?
|
|
| Willy.
|
|
Feb 2 '06 #6

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

"Peter" <pc*****@nospam.nospam> wrote in message
news:eo**************@TK2MSFTNGP14.phx.gbl...
|I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
| getting the following message
|
| ERROR [08001] [IBM] SQL30081N A communication error has been detected.
| Communication protocol being used: "TCP/IP". Communication API being
used:
| "SOCKETS". Location where the error was detected: "10.100.1.69".
| Communication function detecting the error: "connect". Protocol
specific
| error code(s): "10061", "*", "*". SQLSTATE=08001
|
| When I use DB2 control center or setup a ODBC connection it works fine
| Here is my connection string:
|
| Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
|
| Does anyone have a solution for this problem, or how to trouble shoot
this?
|
|
| Thank You
|
|
| Peter
|
|

All I know is that 10061 means "connection refused", don't know what
SQLState 08001 means though.

What kind of client application is this? .NET or other?
Willy.


It is .NET console application

This works:

using (OdbcConnection cn = new OdbcConnection("DSN=TestDB2"))
{
cn.Open();
}
This does not work:

using (DB2Connection cn = new
DB2Connection("Database=mydatabase;Server=db2serve r:6000;UID=testuser;PWD=password"))
{
cn.Open();
}
Feb 2 '06 #7
Willy,

It most certainly does have to do with network access. My response
cited the specific case where it is an ASP.NET application where the worker
process runs under the ASPNET account. That account does not have network
access.

If the database driver is trying to open a socket, then it's going to
fail. It has nothing to do with whether or not it is integrated security.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:%2***************@TK2MSFTNGP09.phx.gbl...
This has nothing to do with network access, integrated security is not
used
here, the connection string contains explicit user credentials.

Willy.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
in
message news:O$**************@TK2MSFTNGP12.phx.gbl...
| Peter,
|
| By chance, are you running this in ASP.NET? If so, ASP.NET runs
under
a
| local user ASPNET by default that does not have network access. If your
DB
| is on another machine, this could definitely be a problem.
|
| The same is true for a program you might have loaded from the
internet
| or your network (assuming it is not from the machine that the DB is on).
|
| Can you give a little more information about the error?
|
| Hope this helps.
|
|
| --
| - Nicholas Paldino [.NET/C# MVP]
| - mv*@spam.guard.caspershouse.com
|
| "Peter" <pc*****@nospam.nospam> wrote in message
| news:eo**************@TK2MSFTNGP14.phx.gbl...
| >I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
| >getting the following message
| >
| > ERROR [08001] [IBM] SQL30081N A communication error has been
detected.
| > Communication protocol being used: "TCP/IP". Communication API being
| > used: "SOCKETS". Location where the error was detected:
"10.100.1.69".
| > Communication function detecting the error: "connect". Protocol
specific
| > error code(s): "10061", "*", "*". SQLSTATE=08001
| >
| > When I use DB2 control center or setup a ODBC connection it works fine
| > Here is my connection string:
| >
| > Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
| >
| > Does anyone have a solution for this problem, or how to trouble shoot
| > this?
| >
| >
| > Thank You
| >
| >
| > Peter
| >
| >
|
|

Feb 2 '06 #8

"Peter" <pc*****@nospam.nospam> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

"Peter" <pc*****@nospam.nospam> wrote in message
news:eo**************@TK2MSFTNGP14.phx.gbl...
|I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
| getting the following message
|
| ERROR [08001] [IBM] SQL30081N A communication error has been detected.
| Communication protocol being used: "TCP/IP". Communication API being
used:
| "SOCKETS". Location where the error was detected: "10.100.1.69".
| Communication function detecting the error: "connect". Protocol
specific
| error code(s): "10061", "*", "*". SQLSTATE=08001
|
| When I use DB2 control center or setup a ODBC connection it works fine
| Here is my connection string:
|
| Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
|
| Does anyone have a solution for this problem, or how to trouble shoot
this?
|
|
| Thank You
|
|
| Peter
|
|

All I know is that 10061 means "connection refused", don't know what
SQLState 08001 means though.

What kind of client application is this? .NET or other?
Willy.


It is .NET console application

This works:

using (OdbcConnection cn = new OdbcConnection("DSN=TestDB2"))
{
cn.Open();
}
This does not work:

using (DB2Connection cn = new
DB2Connection("Database=mydatabase;Server=db2serve r:6000;UID=testuser;PWD=password"))
{
cn.Open();
}


Thanks for your help, your questions made me look at the connection string.

I had wrong port #
the port # should be 60000 not 6000, I was missing one zero.
Thank you very much and I am sorry for wasting everyone's time!!!!!!

Feb 2 '06 #9
Are you providing the information to connect directly to the server or to
connect to the DB2Connect gateway? You have to go through DB2Connect to
connect with the mainframe.

--
Dale Preston
MCAD C#
MCSE, MCDBA
"Peter" wrote:
I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
getting the following message

ERROR [08001] [IBM] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected: "10.100.1.69".
Communication function detecting the error: "connect". Protocol specific
error code(s): "10061", "*", "*". SQLSTATE=08001

When I use DB2 control center or setup a ODBC connection it works fine
Here is my connection string:

Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password

Does anyone have a solution for this problem, or how to trouble shoot this?
Thank You
Peter

Feb 2 '06 #10
It's never a waste of time. We all learn by researching or even thinking
over others' questions.
--
Dale Preston
MCAD C#
MCSE, MCDBA
"Peter" wrote:

"Peter" <pc*****@nospam.nospam> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

"Peter" <pc*****@nospam.nospam> wrote in message
news:eo**************@TK2MSFTNGP14.phx.gbl...
|I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
| getting the following message
|
| ERROR [08001] [IBM] SQL30081N A communication error has been detected.
| Communication protocol being used: "TCP/IP". Communication API being
used:
| "SOCKETS". Location where the error was detected: "10.100.1.69".
| Communication function detecting the error: "connect". Protocol
specific
| error code(s): "10061", "*", "*". SQLSTATE=08001
|
| When I use DB2 control center or setup a ODBC connection it works fine
| Here is my connection string:
|
| Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
|
| Does anyone have a solution for this problem, or how to trouble shoot
this?
|
|
| Thank You
|
|
| Peter
|
|

All I know is that 10061 means "connection refused", don't know what
SQLState 08001 means though.

What kind of client application is this? .NET or other?
Willy.


It is .NET console application

This works:

using (OdbcConnection cn = new OdbcConnection("DSN=TestDB2"))
{
cn.Open();
}
This does not work:

using (DB2Connection cn = new
DB2Connection("Database=mydatabase;Server=db2serve r:6000;UID=testuser;PWD=password"))
{
cn.Open();
}


Thanks for your help, your questions made me look at the connection string.

I had wrong port #
the port # should be 60000 not 6000, I was missing one zero.
Thank you very much and I am sorry for wasting everyone's time!!!!!!

Feb 2 '06 #11
Sorry but you are wrong, It has nothing to do at all with network access:
1. The connection string specifies the credentials used to authenticate with
the DB server, no integrated security is used by the OP, that means that
process identity is (and cannot be) used here.
2. Sockets aren't "secured objects", that is, they aren't protected by the
OS through an ACL, that means an access token is not used, from the systems
point of view everyone can open a socket, so it has nothing to do with a
socket open either.
I have several applications running from asp.net accessing DB servers using
explicit credentials over sockets while ASPNET runs as 'aspnet' or "local
network".
Willy.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:%2****************@TK2MSFTNGP15.phx.gbl...
| Willy,
|
| It most certainly does have to do with network access. My response
| cited the specific case where it is an ASP.NET application where the
worker
| process runs under the ASPNET account. That account does not have network
| access.
|
| If the database driver is trying to open a socket, then it's going to
| fail. It has nothing to do with whether or not it is integrated security.
|
| --
| - Nicholas Paldino [.NET/C# MVP]
| - mv*@spam.guard.caspershouse.com
|
| "Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
| news:%2***************@TK2MSFTNGP09.phx.gbl...
| > This has nothing to do with network access, integrated security is not
| > used
| > here, the connection string contains explicit user credentials.
| >
| > Willy.
| >
| > "Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
| > in
| > message news:O$**************@TK2MSFTNGP12.phx.gbl...
| > | Peter,
| > |
| > | By chance, are you running this in ASP.NET? If so, ASP.NET runs
| > under
| > a
| > | local user ASPNET by default that does not have network access. If
your
| > DB
| > | is on another machine, this could definitely be a problem.
| > |
| > | The same is true for a program you might have loaded from the
| > internet
| > | or your network (assuming it is not from the machine that the DB is
on).
| > |
| > | Can you give a little more information about the error?
| > |
| > | Hope this helps.
| > |
| > |
| > | --
| > | - Nicholas Paldino [.NET/C# MVP]
| > | - mv*@spam.guard.caspershouse.com
| > |
| > | "Peter" <pc*****@nospam.nospam> wrote in message
| > | news:eo**************@TK2MSFTNGP14.phx.gbl...
| > | >I am trying to connect to a DB2 database with IBM.Data.DB2 provider
and
| > | >getting the following message
| > | >
| > | > ERROR [08001] [IBM] SQL30081N A communication error has been
| > detected.
| > | > Communication protocol being used: "TCP/IP". Communication API
being
| > | > used: "SOCKETS". Location where the error was detected:
| > "10.100.1.69".
| > | > Communication function detecting the error: "connect". Protocol
| > specific
| > | > error code(s): "10061", "*", "*". SQLSTATE=08001
| > | >
| > | > When I use DB2 control center or setup a ODBC connection it works
fine
| > | > Here is my connection string:
| > | >
| > | > Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
| > | >
| > | > Does anyone have a solution for this problem, or how to trouble
shoot
| > | > this?
| > | >
| > | >
| > | > Thank You
| > | >
| > | >
| > | > Peter
| > | >
| > | >
| > |
| > |
| >
| >
|
|
Feb 2 '06 #12
No trouble, glad it works.
Just for your own info, the Winsock error "10061" indicates a "connection
refused" error. This is the result of the server actively refusing the
connection request, mostly because the number of connections supported are
exhausted or because the wrong service "port" was selected. In our case it
was the latter.
The SQLSTATE 08001 means "The application requester is unable to establish
the connection".

Willy.

"Peter" <pc*****@nospam.nospam> wrote in message
news:Oe**************@tk2msftngp13.phx.gbl...
|
| "Peter" <pc*****@nospam.nospam> wrote in message
| news:%2***************@TK2MSFTNGP15.phx.gbl...
| >
| > "Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in message
| > news:%2****************@TK2MSFTNGP11.phx.gbl...
| >>
| >> "Peter" <pc*****@nospam.nospam> wrote in message
| >> news:eo**************@TK2MSFTNGP14.phx.gbl...
| >> |I am trying to connect to a DB2 database with IBM.Data.DB2 provider
and
| >> | getting the following message
| >> |
| >> | ERROR [08001] [IBM] SQL30081N A communication error has been
detected.
| >> | Communication protocol being used: "TCP/IP". Communication API being
| >> used:
| >> | "SOCKETS". Location where the error was detected: "10.100.1.69".
| >> | Communication function detecting the error: "connect". Protocol
| >> specific
| >> | error code(s): "10061", "*", "*". SQLSTATE=08001
| >> |
| >> | When I use DB2 control center or setup a ODBC connection it works
fine
| >> | Here is my connection string:
| >> |
| >> | Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password
| >> |
| >> | Does anyone have a solution for this problem, or how to trouble shoot
| >> this?
| >> |
| >> |
| >> | Thank You
| >> |
| >> |
| >> | Peter
| >> |
| >> |
| >>
| >> All I know is that 10061 means "connection refused", don't know what
| >> SQLState 08001 means though.
| >>
| >> What kind of client application is this? .NET or other?
| >>
| >>
| >> Willy.
| >>
| >>
| >
| > It is .NET console application
| >
| > This works:
| >
| > using (OdbcConnection cn = new OdbcConnection("DSN=TestDB2"))
| > {
| > cn.Open();
| > }
| >
| >
| > This does not work:
| >
| > using (DB2Connection cn = new
| >
DB2Connection("Database=mydatabase;Server=db2serve r:6000;UID=testuser;PWD=password"))
| > {
| > cn.Open();
| > }
| >
|
| Thanks for your help, your questions made me look at the connection
string.
|
| I had wrong port #
| the port # should be 60000 not 6000, I was missing one zero.
|
|
| Thank you very much and I am sorry for wasting everyone's time!!!!!!
|
|
|
Feb 2 '06 #13

"Dale" <da******@nospam.nospam> wrote in message
news:61**********************************@microsof t.com...
Are you providing the information to connect directly to the server or to
connect to the DB2Connect gateway? You have to go through DB2Connect to
connect with the mainframe.

--
Dale Preston
MCAD C#
MCSE, MCDBA
"Peter" wrote:
I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
getting the following message

ERROR [08001] [IBM] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being
used:
"SOCKETS". Location where the error was detected: "10.100.1.69".
Communication function detecting the error: "connect". Protocol specific
error code(s): "10061", "*", "*". SQLSTATE=08001

When I use DB2 control center or setup a ODBC connection it works fine
Here is my connection string:

Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password

Does anyone have a solution for this problem, or how to trouble shoot
this?
Thank You
Peter


Thank you everyone for your help!!!

Next time I'll know what to check first, unfortunately next time it will be
totally different problem!
Feb 3 '06 #14
Hello

I am facing a very different issue with db2 connect.
DBconnection string is
Database=mydatabase;UID=userid;PWD=password;poolin g = false

mydatabase is a system DSN created while configuring db2 node.

Sometimes all of sudden i am getting this issue error
"The type initializer for "IBM.Data.DB2.DB2Connection" threw an
exception."

at IBM.Data.DB2.DB2Connection..ctor(String connectionString)
at
Microsoft.Practices.EnterpriseLibrary.Data.DB2.DB2 Database.GetConnection()

at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.LoadDataSet(DBCommandWrapper command, DataSet dataSet

But after restarting the IIS everything works fine for 1/2 days and
again starts same issue.
In some developer machines i am not at all getting this issue.

#1) asp.net and given permission to IWAM_USR under which worker process
is running.
#2) given permission to SQLLIB folder to IWAM_USR.
#3)Added IWAM_USR to the db2users group.
#4) Reregistered DB2client 8.1.7

plz help me out if u have any solutions..
Thanks in advance

"Peter" wrote:

"Dale" <da******@nospam.nospam> wrote in message
news:61**********************************@microsof t.com...
Are you providing the information to connect directly to the server or to
connect to the DB2Connect gateway? You have to go through DB2Connect to
connect with the mainframe.

--
Dale Preston
MCAD C#
MCSE, MCDBA
"Peter" wrote:
I am trying to connect to a DB2 database with IBM.Data.DB2 provider and
getting the following message

ERROR [08001] [IBM] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being
used:
"SOCKETS". Location where the error was detected: "10.100.1.69".
Communication function detecting the error: "connect". Protocol specific
error code(s): "10061", "*", "*". SQLSTATE=08001

When I use DB2 control center or setup a ODBC connection it works fine
Here is my connection string:

Database=mydatabase;Server=db2server:6000;UID=test user;PWD=password

Does anyone have a solution for this problem, or how to trouble shoot
this?
Thank You
Peter


Thank you everyone for your help!!!

Next time I'll know what to check first, unfortunately next time it will be
totally different problem!

Mar 2 '06 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Google Mike | last post by:
After a lot of thought and research, and playing with FreeTDS and InlineTDS, as well as various ODBC connections, I have determined that the fastest and cheapest way to get up and going with PHP on...
2
by: Ramir Santos | last post by:
my analysis server is hosted on a win2k server with IIS, the hosting page is on another machine. I have followed everything as per MS KB article and I could not connect through the analysis server...
4
by: TP | last post by:
Hi, This is probably my 7th post of the day. not spamming, just want to get the questions out, so that I can find the answers and post them back or some good soul can help me out. Right now I...
12
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...
3
by: Jeremy Dillinger | last post by:
I am trying to design a program that will use data from a MySQL database. Currently all the data is being used with PHP scripts from a website. I am also trying to build a software solution that...
0
by: NewsReader | last post by:
Hello, I have been looking around the net for a script to help me connect to and help gather information from Cisco routers/switches. I have pieced together a couple of different scripts from...
0
by: cj.snead | last post by:
Hello, I am having trouble connecting to a remote named instance of SQL Server via Pocket PC. I have had absolutely no luck connecting with VS 2005 (even to a default instance), so I wen't back...
0
by: =?Utf-8?B?R2lkaQ==?= | last post by:
Hi, I've my win32 application which connecting to my sql database. till now i used MSDE as my database and now i want to upgrade to sql express 2005. after the upgrade i tried to connect to the...
10
by: mairhtin o'feannag | last post by:
Hello, I'm having problems connecting to my new v9 db box. The pertinent information is below: DB2_db2inst1 60000/tcp DB2_db2inst1_1 60001/tcp DB2_db2inst1_2 60002/tcp DB2_db2inst1_END...
0
by: aboutjav.com | last post by:
Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.