AS/400 and Crystal Reports

["Adam Lang" <aalang@xxxxxxxxxxxxxxxxxxxx>]

Anyone use Crystal Reports to query the native db2 filesystem?

I received a demo of Crystal Reports to look at and I can only get it half
working with the AS/400.

Using the ODBC driver that came with CA Express, I can get it to display the
tables in a library and then the table to show its fields, but it will not
display dat in the preview window.

Using OLE DB that came with CA Express, I can not even get the connection
configured.  I go to make a new conenction and type in the system name and
my username and password.  Test conenction comes back successful, but when I
hit OK ut has a blank pop up box that says Database Error.

I know the OLE DB connection does work because I have written several Visual
Basic apps that use the OLE DB provider on my computer.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com