Linked Server - AS400 - Missing Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denny - 08 Sep 2006 04:53 GMT

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

Reply to this Message

Helmut Knappe - 08 Sep 2006 07:49 GMT

Hi 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_services/sql400/oledb400/oledb400svr.html,
download the eval and give it a try.

Let me know, if it helps.

Regards,
Helmut

> From: "Denny" <denny@newsgroup.com>
> Subject: Linked Server - AS400 - Missing Data
[quoted text clipped - 14 lines]
>
> Denny

Reply to this Message