Re: DECS and SQL

["Michael Bohlken" <Mike.Bohlken@xxxxxxxxxxxxxxx>]

Walter,

I looked at IBM's website on DB2 Connect and don't see anything about
connecting the iSeries to the SQL server?  What I looked at doesnt run on
the 400.        Is it possible you can post a website link that explains
this?

Thanks

Mike







"Walter Scanlan" <wscanlan@us.ibm.com>
Sent by: domino400-admin@midrange.com
03/07/02 11:20 PM
Please respond to domino400


        To:     domino400@midrange.com
        cc:     domino400@midrange.com, domino400-admin@midrange.com
        Subject:        Re: DECS and SQL



Rob,
      You are not out of luck.

There is a product call DB2 Connect.  (sorry it is chargable)

This product allows the iSeries to communicate with an SQL server.  DECS
could then be used.

Another solution would be to request the data via the XML if you are
running R510.

I hope this helps

Walter Scanlan
Advisory Software Engineer
Domino For iSeries Team Leader
Internet  WSCANLAN@US.IBM.COM




                      "Michael Bohlken"
                      <Mike.Bohlken@redwi         To:
domino400@midrange.com
                      ngshoe.com>                 cc:
                      Sent by:                    Subject: Re: DECS and
SQL
                      domino400-admin@mid
                      range.com


                      03/07/2002 09:11 AM
                      Please respond to
                      domino400





This document expires on 06/05/2002

I called Lotus on my issue...  They basically said I was  S.O.L. on the
S.Q.L.

Thanks Anyhow

mb





rob@dekko.com
Sent by: domino400-admin@midrange.com
03/07/02 09:10 AM
Please respond to domino400


        To:     domino400@midrange.com
        cc:
        Subject:        Re: DECS and SQL



I am not sure.  I would have to study the manuals, redbooks and whatnot.

I wonder if you can do a ADDRDBDIRE and access the SQL server with native
iSeries tools?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    "Michael Bohlken"
                    <Mike.Bohlken@redwin       To: domino400@midrange.com
                    gshoe.com>                 cc:
                    Sent by:                   Fax to:
                    domino400-admin@midr       Subject:     DECS and SQL
                    ange.com


                    03/06/2002 08:02 AM
                    Please respond to
                    domino400






Hi,

I have a database on an Microsoft SQL server that I would like to connect
to in a Notes database.  Is there a way to use DECS to do this, or,
because I am using AS400 as my server platform, am I stuck with DB2?

Thanks

Mike

_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.





_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.




_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.





_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.