When i try to connect to DB2 base


(FOC1394) CONNECT FAILURE
(FOC1400) SQLCODE IS -99999 (HEX: FFFE7961)
: [S1009] [IBM][CLI Driver] CLI0124E . SQL
: STATE=S1009
(FOC1405) SQL PREPARE ERROR.
(FOC1394) CONNECT FAILURE
(FOC1400) SQLCODE IS -99999 (HEX: FFFE7961)
: [S1009] [IBM][CLI Driver] CLI0124E . SQL
: STATE=S1009
(FOC1405) SQL PREPARE ERROR.
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD
BYPASSING TO END OF COMMAND

This message has been edited. Last edited by: Kerry,

Looks like the data adapter to make WebFOCUS connections to your database has not been configured. Please check with your admin.

If this is not the issue, check your database - whether it is up and running. Fire a query against the database outside of WebFOCUS.

Do ensure that the username/pswd which you are using to access the database, has 'read' access to it.

Hope this helps.

Rgds
Syed

Another debugging tool is to type:

SQL DB2 ?

from an adhoc tool. It will tell you what the setup for your DB2 adapter is.

Yes, SQL DB2, local database(WF and DB2 stay on one computer0,name of base - TOOLSDB(default DB), login as DB2ADMIN

Searching for this issue on the internet gave me this result:

Issue:
[IBM][CLI Driver] CLI0124E Invalid argument value.
SQLSTATE=S1009, Connector 'db2', Method -Connect- (0xFFFE7961)

Resolution:
Check that the database name is correct -- this is set up at the native client level.
If using 'odbc' instead of 'db2', set up a system connection in the "Data Sources (ODBC)" control panel.

Thank you all very much!!!!