Re: DECS and SQL

[rob@xxxxxxxxx]

Walter,

Glad to see you're back in town.

Actually I was just trying to help the other fellow.

"request the data through the XML"  What does that mean?  I thought that
XML was just a scripting language for data.  Are you saying that this also
a product?  And it is used as a method to interconnect between two
disparate data sources?  If so, how do I find out more information about
that?

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



                    "Walter Scanlan"
                    <wscanlan@us.ibm.c       To:     domino400@midrange.com
                    om>                      cc:     domino400@midrange.com, 
domino400-admin@midrange.com
                    Sent by:                 Fax to:
                    domino400-admin@mi       Subject:     Re: DECS and SQL
                    drange.com


                    03/08/2002 12:20
                    AM
                    Please respond to
                    domino400







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.