Linked Server - AS400 - Missing Data

From: "Denny" <denny@.newsgroup.com>
Subject: Linked Server - AS400 - Missing Data
Date: Thursday, September 07, 2006 3:34 PM
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,
DennyHi Denny,
Which ODBC driver are you using, IBM Client Access?
Since OLEDB is preferable for setting up a Linked Server anyway, you might
check out HiT OLEDB/400.
I know a bunch of customers who had similar problems and are happy with it.
Take a look at
http://www.hitsw.com/products_servi...edb400svr.html,
download the eval and give it a try.
Let me know, if it helps.
Regards,
Helmut
"Denny" <denny@.newsgroup.com> schrieb im Newsbeitrag
news:uHyVrpv0GHA.480@.TK2MSFTNGP06.phx.gbl...
> From: "Denny" <denny@.newsgroup.com>
> Subject: Linked Server - AS400 - Missing Data
> Date: Thursday, September 07, 2006 3:34 PM
> 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
>
>