Using DB2, ODBC, and Crystal Reports 8.5 in .NET

[chix001]

Hi -

I have a .NET web application that uses Crystal Reports (Developer Edition 8.5). It loads a predefined report, passes some parameters that the user enters on the web form (login info, and filtering info). The report goes against a DB2 view.

I have the DB2 connection set up in ODBC (using DB2Connect version 6 I think).

The problem is that when I use the Crystal Reports application to view the report, my login parameters connect successfully, but when I try to load the report in the web app, Crystal returns a 'login failure' error.

I can get the web app to server the report correctly if I put MY credentials into the DB2Connect Driver in ODBC (i.e hard-code them), but obviously I don't want to do that for each user that will use this web app.

Can someone help me understand why this happens and how to get around it without hardcoding a user ID into the ODBC driver?

Thanks, CHIX001

 

[chix001]

I just found the reason why - it was totally a bug in the application

Thanks anyways.

CHIX001