We support Kofax scanning software and are mocking up a demo for a client that uses the Kofax Transformation Module. The Client owns DB2 so we decided to use DB2 in our mockup. We have installed DB2- free version and IBM Data Studio. We have created a stored procedure and are using the "SAMPLE" tables. We can use IBM Data Studio to select the information out of the EMPLOYEE table and all looks good. I have set up an ODBC connection to the table. Kofax an connect to the database and list the tables but it can not read the employee table using the same password and user id that data studio is using . Also when I try to read the table with a query, I get a Microsoft Jet data base error that the table can not be found.
ANY IDEAS WHAT I NEED TO DO TO GET THIE TO WORK….. Thanks
The version of DB2 is 10.5 and the version of Kofax is 10, the version of KTM is 5.5 with all service packs
The OS is windows 7 Pro.,