DB2 connection does not show tables

[bwschiek]

Hi:

I am using IBM's Client Access Express to connect via ODBC to our DB2 database on our AS/400. I can connect to the desired library, but it only displays the stored proceedures within the library, but no tables. If I use IBM's Operations Navigator, I can open the database, and drill down into the tables in that library.

I have set up my ODBC connection according to the instructions from Crystal Decisions, but still no luck. Am I missing something on the DB2 side?

Thanks.

 

[synapsevampire]

Perhaps on the Crystal side, check the Options in the Data Explorer, you'll see check boxes fior Tables, Views, SP's, etc.

Select all data types of interest.

-k