DB2 Connection Issue

[OldButStillLearning]

OK, I am trying to connect to DB2 (z/OS). I have successfully made the
connection to the database in the Server Explorer. I am also able to
successfully log in to DB2 when I am testing the "System DSN" in the ODBC
configuration tool (MS).

When In server Explorer, I click on my connection object and then select
properties to get the connection information. I then copy this connection
information and place it into a string object so that I can configure all the
connection information in my code. I add to that connection information the
"Password" as this does not show up in the properties.

When I attempt to connect to the Database, I get and error which suggest
that the user ID/Password is invalid. I know that this password and user ID
is valid, so it must be something else. A format issue or perhaps there is
somethine which is missing in the properties other then password. Below is
my connection information. I presume that I am connecting via ODBC (the
error mseeage points this out), but there is nothing in the properties for
the connection (within server explorer) which specifies that.

Dsn=DB29;uid=XX XXXX;pwd=YYYYYY ,dbalias=DB29;s chemalist='GATS C'

Here is the error message that I am getting...
ERROR [08001] [IBM][CLI Driver] SQL30082N
Attempt to establish connection failed with security reason \"24\"
(\"USERNAME AND/OR PASSWORD INVALID\"). SQLSTATE=08001\ r\n\r\nERROR [IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAt tr failed"}
System.Exceptio n {System.Data.Od bc.OdbcExceptio n}

SO what might be the problem?

Thanks in advance for your assistance!!

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Take a look at connectionstrin gs.com

OLE DB, OleDbConnection (.NET) from ms
a.. TCP/IP:

"Provider=DB2OL EDB;Network Transport Library=TCPIP;N etwork
Address=XXX.XXX .XXX.XXX;Initia l Catalog=MyCtlg; Package
Collection=MyPk gCol;Default Schema=Schema;U ser ID=MyUser;Passw ord=MyPW"

b.. APPC:

"Provider=DB2OL EDB;APPC Local LU Alias=MyAlias;A PPC Remote LU
Alias=MyRemote; Initial Catalog=MyCtlg; Package Collection=MyPk gCol;Default
Schema=Schema;U ser ID=MyUser;Passw ord=MyPW"
ODBC
a.. Standard:

"driver={IB M DB2 ODBC
DRIVER};Databas e=myDbName;host name=myServerNa me;port=myPortN um;protocol=TCP IP;
uid=myUserName; pwd=myPwd"
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"OldButStillLea rning" <Ol************ *****@discussio ns.microsoft.co mwrote
in message news:65******** *************** ***********@mic rosoft.com...

OK, I am trying to connect to DB2 (z/OS). I have successfully made the
connection to the database in the Server Explorer. I am also able to
successfully log in to DB2 when I am testing the "System DSN" in the ODBC
configuration tool (MS).

When In server Explorer, I click on my connection object and then select
properties to get the connection information. I then copy this connection
information and place it into a string object so that I can configure all
the
connection information in my code. I add to that connection information
the
"Password" as this does not show up in the properties.

When I attempt to connect to the Database, I get and error which suggest
that the user ID/Password is invalid. I know that this password and user
ID
is valid, so it must be something else. A format issue or perhaps there
is
somethine which is missing in the properties other then password. Below
is
my connection information. I presume that I am connecting via ODBC (the
error mseeage points this out), but there is nothing in the properties for
the connection (within server explorer) which specifies that.

Dsn=DB29;uid=XX XXXX;pwd=YYYYYY ,dbalias=DB29;s chemalist='GATS C'

Here is the error message that I am getting...
ERROR [08001] [IBM][CLI Driver] SQL30082N
Attempt to establish connection failed with security reason \"24\"
(\"USERNAME AND/OR PASSWORD INVALID\"). SQLSTATE=08001\ r\n\r\nERROR
[IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAt tr failed"}
System.Exceptio n {System.Data.Od bc.OdbcExceptio n}

SO what might be the problem?

Thanks in advance for your assistance!!