RE: Sql Server ODBC

[Jim Knight <jknight@xxxxxxx>]

Thanks Larry.  Actually, we have a requirement where the Sql7
needs to access the 400 data via ODBC.  Any ideas?
JK

-----Original Message-----
From: Glenn Birnbaum 
Sent: Thursday, September 23, 1999 9:23 AM
To: Jim Knight
Subject: FW: Sql Server ODBC




-----Original Message-----
From: Larry Bolhuis [mailto:lbolhui@ibm.net] 
Sent: Wednesday, September 22, 1999 5:33 PM
To: MIDRANGE-L@midrange.com
Subject: Re: Sql Server ODBC


Hmmmm, If you mean that the AS/400 needs to access data that resides on SQL7 
then
I don't think that the AS/400 can directly access that data.  That is to say 
that
the AS/400 does not have an ODBC Client.  To do this we have done: Batch FTP 
(NOT
real time), Client Access file transfers (Also NOT real time but formatting is
much better) or replication products such as DataMirror's Transformation 
Server. 
Very Very close to real time but keeps a copy of the data on the AS/400.

 - Larry

Note: We Represent DataMirror.

Jim Knight wrote:
> 
> We have a requirement to do ODBC data transfer from SqlServer 7.0,
> on NT, to the AS400.  Is anyone aware of or currently doing SqlServer
> ODBC from an NT server to the 400?
> If so, do we need to buy a separate package to do this?
> They do not want to use Rumba DRDA-32.
> 
> TIA
> Jim K
> 
> +---
> | 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
> +---

-- 
Larry Bolhuis         | What do You want to Reload today?
Arbor Solutions, Inc  |
(616) 451-2500        | 
(616) 451-2571 -fax   | Two rules to success in life:
lbolhui@ibm.net       | 1. Never tell people everything you know.
+---
| 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
+---