Web Server:
- Crystal Reports 8.5
- UDB 8.1 FixPak 10 (FP10_WR21362_RTCL.exe)
- IIS 5.0
- Windows 2000

DB Server:
- DB2 UDB, FixPak 8
- AIX 5.2

Problem (high level):

Crystal Reports 8.5, when used as an object within an ASP page (abc.asp), works with UDB 7 Runtime Client FixPack 7, but does not work with UDB 8.1 Runtime Client FixPak 10. The ASP page hangs and times-out. However, the report (abc.rpt) does display data with both UDB client versions when run directly.

Problem (details):

Highlights of the code in abc.asp:

1. Set session("oApp") = Server.CreateObject("CrystalRuntime.Application")
2. Set session("oRpt") = session("oApp").OpenReport(Path & "\Rpt\" & strAuditRptName, 1)
3. Set crtable = session("oRpt").Database.Tables.Item(1)
4. strLocation = crtable.Location
5. crtable.SetLogonInfo CStr(strDSN), CStr(strDatabase), CStr(strDBUserId), CStr(strDBPassword)
6. blnDBConn = crtable.testconnectivity

Lines 1-5 work fine with both UDB clients.
Line 6 works fine with UDB 7 client and returns a value of "True".

*** However, Line 6 with UDB 8 client does not return a value. And this is what I believe is causing abc.asp to hang.

Any suggestions on how to resolve this error (crtable.testconnectivity not returning a value with UDB 8 client) would be greatly appreciated. It is holding us back on upgrading our web servers to UDB 8 client.