Re: AS/400 SQL from AS/400 to MS/SQL

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

Mark--

> Can I query from my AS/400 V4R3M0 to an MS/SQL Server?
>
> Using TCP?
>
> Without other 3rd party products?

You can do it without third-party products using OLE DB from a Windows
client app and you can also kludge together facilities using FTP and BCP.
But any homegrown solution will be kludgy at best and will cost you more in
time than you'd spend buying a good tool. Check out  www.universal.com. They
have a rationally-priced product called Data Distributor that does a great
job (Disclaimer: I am in no way affiliated with Universal and I don't care
if you buy their stuff or not!)

rp


----- Original Message -----
From: Mark Villa <markvilla@knology.net>
To: MIDRANGE-L <MIDRANGE-L@midrange.com>
Sent: Tuesday, March 14, 2000 8:44 AM
Subject: AS/400 SQL from AS/400 to MS/SQL


>
> Which products?
>
> Any examples on the net?
>
> Does vica-versa work better?
>
> Any consultants for on-site training?
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---