Linked Server - AS400 - Missing Data

I set up a linked server from SQL to an AS400 and it connects ok, but does
not return all data. For example, if the as400 file has 1059 records, it
returns 1001, if it has 4080, it will return 4004, and so on. The ODBC
connection works fine though, it is only when I use the ODBC connection thru
a Linked Server that I have a problem.
It appears as if it drops the last physical block.
Any help would be appreciated, this is driving me nuts.
Thanks,
DennyAre you accessing logical files or physical files on the
400? Also, what provider options were selected when this was
set up?
And...if you are using the CA drivers have you made sure the
CA on the SQL Server box is at that same patch level as your
AS400? Can't remember offhand...I think the option to check
and update it is on the Client Access menu somewhere.
-Sue
On Thu, 7 Sep 2006 15:34:33 -0700, "Denny"
<denny@.newsgroup.com> wrote:
>I set up a linked server from SQL to an AS400 and it connects ok, but does
>not return all data. For example, if the as400 file has 1059 records, it
>returns 1001, if it has 4080, it will return 4004, and so on. The ODBC
>connection works fine though, it is only when I use the ODBC connection thru
>a Linked Server that I have a problem.
>It appears as if it drops the last physical block.
>Any help would be appreciated, this is driving me nuts.
>Thanks,
>Denny
>