linked server doesn't return all rows for some tables

Hello,

I created a linked server in sql server 2005 which links to a AS400 DB. I use ODBC driver.

For some tables, it return all data but for another tables, it only return part of the rows.

How it may happen?

Thanks

After I applied AS400 client patch, this problem is fixed.

Thanks

|||Hello,
I'm having the same problem with some queries, could you please tell me which patch to install so as to solve my problem ? I would appreciate a url for the download. Thank you very much.