Hi,
I am trying to integrate crystal reports with java. basically trying
to query the database to get the report, modify the parameters, run
and view(display ) it in the jsp.
i guess i have the right java code and jsp. i can get the report,
modify the params but i am not able to display the report. it throws
the following error

"Error in file <my Report.rpt>:  Failed to load database information"

we are using DB2 database and its a native connection. is the error
related to  the DB connection? would appreciate if someone could help
me out. whats the reason for this error and whats the solution to it?
i can email you the code too(both java class and the jsp). i guess i
have written the entire code.

also, i am able to display a static report meaning which doesnt hit
the DB, has saved code.


Thanks,
Perukav

According to http://support.businessobjects.com/library/kbase/articles/c2015340.asp?ref=devzone_reporting_archive
 
"This error message appears because Crystal Reports does not support
the use of command objects with native connections to specific
database types. The database types are:

· Specific SQL-type databases: IBM DB2, Sybase, Informix 

· Specific PC-type databases: Paradox and Microsoft FoxPro "


So it looks like you may have to use an ODBC connection.