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=XXXXXX;pwd=YYYYYY,dbalias=DB29;schema list='GATSC'
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 SQLSetConnectAttr failed"}
System.Exception {System.Data.Odbc.OdbcException}
SO what might be the problem?
Thanks in advance for your assistance!!