We have two brand new servers that have WF 7.1.3 installed on them. The data source is DB2. On both machines we have installed the DB2 Client software. One machine works correctly and successfully connects to the DB2 data source, the other keeps giving the same error:


(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED
(FOC1479) ERROR CONNECTING TO SQL DATABASE


Both machines are running the same security level. As far as I can both machines have the same configuration setups (edasprof.prf, etc..), yet one works and the other doesn't.

Does anyone have a suggestion ?

What platform is this on? You say the DB2 client is installed. Are you able to use the DB2 client command line interface and connect to the DB2 subsystem?

Bryan Klimek
Mayo Clinic

Your best bet is turn the traces on to see what is going on.

Hi michka,

Has this issue been resolved? Did the suggestion of turning on the traces help you in finding the cause of the proble?

I ran some search on Information Builders' online documents and came across the following topics which may be of interest:

Resolving FOC1400, FOC1488 and FOC1479 Errors for the DB2 Adapter

Cannot create DB2 Data Adapter on Server Console

You will need to have an InfoResponse userID/password to access these documents.

Hope this helps.

Cheers,

Kerry

Thanks to everyone for the suggestions. After trying several different options with no luck, we brought the DB2 administrator in to look at it. Turns out there was a problem with the DB2 Client installation (security/permissions). He removed, then re-installed the software and we are now able to connect and retrieve data.