Connecting to DB2 in ZABO 6.5

[timmile]

Hi,
I'm having trouble getting ZABO to connect to any DB2 data source.

Configurations:
Webi Server OS: Windows 2000
Client PC OS: Windows 2000 professional
Repository Database: SQL Server 2000
Business Objects/Webi Version: 6.5
Middleware to connect to DB2 data: ISeries Access 5.2 (same as Client Access 5.2)

The strange thing is that I can connect to the DB2 data source using full client on my PC, Webi, or full client on the Webi server.

Tech support is not helping much. I think this may be bug because as I said before Full Client and Webi can connect, but when I run ZABO from my PC or any other user PC I get an unhandled exception error.

I have copied out the SQL the report generates and was able to run it successfully on my PC and the Webi server using a SQL tool (WinSQL) and the same ODBC that ZABO should be using.

Has anyone else experienced this problem?

Thanks,
Tim

 

[blom0344]

Are you connecting to an AS400 DB2 system?

Make sure that client Access version on both clients AND server are the same. I have experienced some weird stuff with older clients on updated server installations....

Ties Blom
Information analyst
tbl@shimano-eu.com