I don't know how the administrator set up the DB2 data adapter setting, but when he runs a fex from the Procedures tab of the WebFOCUS Server Console, he gets the following errors:
(FOC1394) CONNECT FAILURE (FOC1400) SQLCODE IS -30082 (HEX: FFFF8A7E) : [08001] [IBM][CLI Driver] SQL30082N Attempt to establish connection fai : led with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQL
Is there a command I can put in the procedure that does the login connection to DB2?
Thanks a lot,This message has been edited. Last edited by: Francis Mariani,
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 29, 2009, 03:31 PM
Francis Mariani
ENGINE [DB2] SET CONNECTION_ATTRIBUTES connection DSN_name/userid,password
Sorry about that, I should have checked the manual, I was in a bit of a panic.
Adapter Administration for UNIX, Windows, OpenVMS, i5/OS, and z/OS > Using the Adapter for DB2 > How to Declare Connection Attributes Manually.
Cheers, thanks a lot.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 30, 2009, 02:22 AM
Tony A
quote:
I should have checked the manual
Very unusual for you not to have done so Francis
T
January 30, 2009, 09:29 AM
Francis Mariani
I was in a panic trying to assist B.J. from Tech Support with a bug we have in 7.6.5
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 30, 2009, 10:31 AM
Tony A
quote:
a bug we have in 7.6.5
Surely not?
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10