Re: AS400 as ODBC client

DRDA is the way to get it done.  The "hitch" is that you need to get the 
DRDA drivers for the DBMS that you are trying to access.  For example:

Microsoft, use the OLE DB Provider for AS/400 & VSAM 
http://msdn.microsoft.com/library/psdk/his/thorappa_34de.htm 

ORACLE, use Oracle Access Manager for AS/400 
http://technet.oracle.com/doc/gateways/am4as400/toc.fm.html 
(looks like you have to signup, which is free)

SYBASE, use Direct Connect for AS/400 
http://manuals.sybase.com/onlinebooks/group-dc/dca1200e/as4axsrv/@Generic__BookView


More than what you asked for, but if we swing a broad ax..........




Bryan Dietz
______________________________________________

"Goodbar, Loyd 

> I've checked the archives, but turned up little.
>
> I want to use the AS400 as a client to access data from a Microsoft SQL
> server (V7) database. [The database & server is in another location in
> another state, so cannot be put on our AS/400. Also corporately mandated 
the
> data is on the NT server.] One solution I've heard is "use DRDA". Does 
MS
> SQL server have a DRDA component to allow access from the AS/400? 
Another
> idea is to run SNA server on an NT box to broker ODBC connections for 
the
> AS/400.
>
> Does anyone have this working? Any advice is appreciated!
>
> --
> Loyd Goodbar
> Programmer/Analyst
> BorgWarner Incorporated
> Air/Fluid Systems, Water Valley, MS
>
+---
| 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
+---