Re: Sql Server ODBC

[Larry Bolhuis <lbolhui@xxxxxxx>]

Well this is more likely.  Certainly you can install CA and use it's ODBC 
drivers
on the NT side.  Then it is just a matter of getting Sql7 to use that ODBC link
to the 400.  That's not my area of expertise but it sounds simple from that
point. (which means it probably isn't)

Additionally products such as Transformation Server can replicate AS/400 data to
Sql7 in near real time as well.  Same problems as going the other way in that 
you
need to have space on the NT side to hold the mirrored copy.

 hth

 - Larry

Jim Knight wrote:
> 
> Thanks Larry.  Actually, we have a requirement where the Sql7
> needs to access the 400 data via ODBC.  Any ideas?
> JK
> 
> 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
-- 
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
+---