OPENQUERY ISSUE

Hi,

I have SQL 2005 Enterprise set up with Linked Server using ODBC Driver
(System DSN) to access an AS/400.

When I run the subquery below, I get 2002328 records.

SELECT * FROM OPENQUERY(SILVER, 'SELECT COUNT(*)FROM LOHTDLFP.MPMNMCP_X')

But, only 24 Records for the following one.

SELECT * FROM OPENQUERY(SILVER, 'SELECT * FROM LOHTDLFP.MPMNMCP_X')

Any ideas why the difference here? Is there something I should be looking at
a DSN configuration level?

Thanks very much,

Marcelo.