Re: Moving As/400 data to SQL Server

[Richard Schoen <richard@xxxxxxxxxxxxxxxxx>]

Just install the ACS Windows package and you'll get the data drivers as Craig mentions.

With the DB drivers you can also query data directly from IBM i via Linked Tables as well as any other PC based apps. 

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
----------------------------------------------------------------------

message: 1
date: Sun, 22 Nov 2020 16:14:32 -0800
from: "Craig Pelkie" <craig@xxxxxxxxxx>
subject: RE: Moving As/400 data to SQL Server

I don't cover the ACS option. My understanding is that IBM split the Windows database providers (ODBC, OLE DB, .NET) out into a separate package. You will need that to work with the course.

Craig Pelkie

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Jack Kingsley
Sent: Friday, November 13, 2020 2:11 AM
To: Midrange Systems Technical Discussion
Subject: Re: Moving As/400 data to SQL Server

Craig, does this cover ACS as well.

On Thu, Nov 12, 2020 at 7:15 PM Craig Pelkie <craig@xxxxxxxxxx> wrote:

> Link to a course that describes many techniques for working with 
> Microsoft SQL Server in an IBM i environment:
>
> http://www.web400.com/courses/sqlsvr
>
> Craig Pelkie