RE: AS400 as ODBC client

["Art Tostaine, Jr." <art@xxxxxxxxxxx>]

I agree.  DRDA, but where do you get it from?  I thought for awhile that it
was part of SNA Server, but we couldn't install that on our server.

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of DeLong, Eric
Sent: Friday, May 04, 2001 1:27 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: AS400 as ODBC client


Loyd,

I've tried to chase this rabbit down several times already. The answer is
"Yes, there is a DRDA component for SQL Server". Just who has this piece and
where to get it seems to be the big secret. I have seen references to a
Microsoft project called "BABYLON" which appears to address this need.
However, I can't find any direct references to Babylon and DRDA in M$
support. It's been a little while since I last looked, though.

Eric DeLong

-----Original Message-----
From: Goodbar, Loyd (AFS-Water Valley) [mailto:LGoodbar@afs.bwauto.com]
Sent: Friday, May 04, 2001 11:22 AM
To: 'midrange-l@midrange.com'
Subject: AS400 as ODBC client


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
+---

+---
| 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
+---