Re: AS/400 DSN on SQL Server

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I assume you're trying to set up a linked server?

https://www-01.ibm.com/support/docview.wss?uid=nas8N1014514

Once you get connected, note the following:

-- Pull all rows from the table(s) back to MS SQL server and do the where
locally
select * from LINKEDSVR.MYIBMI.MYLIB.MYTBL where locnbr = '00335';

-- Sends the statement to linked server for processing
select * from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
''00335''');

--OPENQUERY() isn't just for SELECTS
delete from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
''00335''');

Charles

On Fri, Feb 10, 2017 at 1:48 PM, Sipa Sayakhom <sipa@xxxxxxxxxxxx> wrote:

> Hi,
>
> Can you please point me in the right direction?  We need to connect our SQL
> server to the A/S400?  I've installed IBM Access for Windows 7.1, and I'm
> not able to connect from SQL Studio 2014 to the A/S400.
>
> Thank you,
>
> SIPA SAYAKHOM
> Don Quijote (USA) Co., Ltd.
> 801 Kaheka St., Honolulu, HI 96814
> Phone: 808-973-6040
> E-mail: sipa@xxxxxxxxxxxx
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD