I am having a problem when trying to add a DB2 data
connection using the IBM DB2 provider for a backend AS400
system.
On the "Add DB2 DataConnection" window, I'm entering the
following:
- I'm entering the IP address of the server
- I just put in any alias name
- I put the "UserName" and "Password" in
- I put the default schema in

I get the following error:
Test connection failed: 0: Error occurred: [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: "[IP of my iSeries server]". Communication
function detecting the
error: "connect". Protocol specific error code
(s): "10061", "*", "*",
SQLSTATE=08001: -30081: IBM.Data.DB2: 08001

Without this, I can't use the IBM DB2 provider. I'm able
to connect using the OLEDB provider with the same info,
but not the IBM DB2 provider.

Hi,

check http://www.connectionstrings.com/.

HTH
Regards
Joyjit

"bill yeager" <(E-Mail Removed)> wrote in message
news:146d01c499b2$07b7a200$(E-Mail Removed)...
> I am having a problem when trying to add a DB2 data
> connection using the IBM DB2 provider for a backend AS400
> system.
> On the "Add DB2 DataConnection" window, I'm entering the
> following:
> - I'm entering the IP address of the server
> - I just put in any alias name
> - I put the "UserName" and "Password" in
> - I put the default schema in
>
> I get the following error:
> Test connection failed: 0: Error occurred: [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: "[IP of my iSeries server]". Communication
> function detecting the
> error: "connect". Protocol specific error code
> (s): "10061", "*", "*",
> SQLSTATE=08001: -30081: IBM.Data.DB2: 08001
>
> Without this, I can't use the IBM DB2 provider. I'm able
> to connect using the OLEDB provider with the same info,
> but not the IBM DB2 provider.