RE: How do I connect from iSeries to MS SQL Server 2000?

As Rob mentioned on the other list.

The multi-machine access is often driven by the availability of an application 
on another platform.

In addition, it is often driven by the legacy of iSeries folks not being able 
to get something done quick enough and/or with a nice pretty GUI and the PC 
folks being able to whip "something" out in a few days.

No need to go into how bad that legacy is Joe.  Believe me I know.  But I've 
only been here 18 months.  I'm trying to change it, but it is difficult when 
"green screen AS-400" is so deeply embedded in both the iSeries folks, 
management, and users.  Particularly when the home-grown green screen 
application quality and functionality leave a bad taste in the mouth.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Joe Pluta
> Sent: Tuesday, June 07, 2005 9:08 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: How do I connect from iSeries to MS SQL Server 2000?
> 
> 
> Who is "we"?  In the things my clients need, this sort of 
> multi-machine
> access ranges from a "nice to have" to a "why would I need that".  I
> guess I'm naïve.
> 
> Joe
> 
> 
> > From: Wilt, Charles
> > 
> > What we want to be able to do is use SQL, including SQL embedded in
> RPG,
> > to access data on a remote machine.  More specifically, 
> what I want is
> to
> > be able to do a CREATE ALIAS MYTABLE for REMOTE/SCHEMA/TABLE and be
> able
> > to use it in a SQL statement as if it was a local table.
> 
> 
> -- 
> 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.
> 
>