RE: How Do I Connect An AS/400 To SQL Server?

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

You might check the archives.  Someone mentioned awhile ago that you could get 
a drda plugin for sql server, i believe it was on the
SNA server install CD.

I tried to do it, but I don't know SQL server at all and I couldn't find anyone 
who knew SQL server and understood the MS
documentation on DRDA.

This has come up before and I've never seen a solution we could use.

We wound up having someone write a simple ASP on IE that connects to the SQL 
database.  We use Brad Stones GETURI to post SQL
commands to the website, (sorry about the formatting) :

CHGVAR     VAR(&URL) +
VALUE('http://x.x.x.x/docudb/as400sqlexec.asp?sql=select+id+from+dpobjects+where+title+=+'
*CAT &APOST *CAT &PRO *TCAT + &APOST *CAT '+and+field1+=+' *CAT &APOST *CAT 
&BLDR *CAT &APOST)

GETURI     URI(&URL) OUTPUT(*FILE) FILE(QTEMP/WEB)

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

> -----Original Message-----
> From: midrange-l-admin@midrange.com
> [mailto:midrange-l-admin@midrange.com]On Behalf Of Vernon Hamberg
> Sent: Thursday, March 07, 2002 5:34 PM
> To: midrange-l@midrange.com
> Subject: Re: How Do I Connect An AS/400 To SQL Server?
>
>
> I've been there, done that. AFAIK, SQL Server knows nothing about DRDA. MS
> doesn't provide an *ARD for SQL Server. And IBM  says it's up to the
> vendor. It's always struck me as a stupid IBM-MS war.
>
> Get'm to use UDB?   HehHehHeh
>
> At 03:37 PM 3/7/02 -0600, you wrote:
> >My mission is to be able to issue the statement, "Connect to sqlserver user
> >joe using schmoe" on my AS/400.  We currently connect remotely to other
> >AS/400s using DRDA over SNA.  We also have clients connecting to the AS/400
> >using the client access ODBC driver on windows.  So, I am semi-confident
> >that the required ports are open and available.
> >
>
> -snip-
>
> >I assume I need one of the following and have been searching the web for
> >them without success.
> >
> >1.  Client SQL Server driver for AS/400
> >2.  DRDA Application Server for Microsoft SQL Server
> >
> >Any help appreciated,
> >
> >Mark
> >
> >_______________________________________________
> >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> >To post a message email: MIDRANGE-L@midrange.com
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> >or email: MIDRANGE-L-request@midrange.com
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/midrange-l.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>