RE: Connecting to a remote database

["OSullivan, Patrick" <OSullivanP@xxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Susan,
Thanks for your reply.  We had already issued all of the steps below, but
still nothing.

Pat.

-----Original Message-----
From: Susan J Funk [mailto:funks@us.ibm.com]
Sent: Friday, November 09, 2001 5:40 PM
To: java400-l@midrange.com
Subject: Re: Connecting to a remote database



>From the Toolbox programmers' guide:

"Running IBM Toolbox for Java in a client/server environment requires that
you enable the QUSER user profile, start the host
servers, and have TCP/IP running. Perform these actions from an iSeries
command line by running the following commands:

   1.Type DSPUSRPRF USRPRF(QUSER) and press ENTER to enable the QUSER user
profile. The resulting display
     shows the status for QUSER.
   2.Type STRHOSTSVR and press ENTER to start the OS/400 host servers.
   3.Type STRTCPSVR SERVER(*DDM) to start the TCP/IP server (with *DDM
specified for the Server parameter)"

Hope this helps,

Susan Funk (funks@us.ibm.com)




                    "Bharath V.S.
                    Dhurjati"                To:
<java400-l@midrange.com>
                    <bharath@pswebwork       cc:
                    s.com>                   Subject:     Re: Connecting to
a remote database
                    Sent by:
                    java400-l-admin@mi
                    drange.com


                    11/09/01 04:37 PM
                    Please respond to
                    java400-l





We faced a similar problem with connecting from a Win2K m/c to AS/400 using
the Toolbox JDBC.

Our DB folks then "did something with RDBDIRE"  to fix it.

Also they verified that "servers were running on the AS/400 to service
incoming DB requests".
(Something with QZDASRDSD?)

Sorry to be so vague, but some one who knows what these mean on the AS/400
can probably figure it out.

HTH.

Regards,
Bharath.

----- Original Message -----
From: "OSullivan, Patrick" <OSullivanP@bis.adp.com>
To: <java400-l@midrange.com>
Sent: Friday, November 09, 2001 4:43 PM
Subject: RE: Connecting to a remote database


> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> Jim,
> We are using java toolkit driver ....which is (
> com.ibm.as400.access.AS400JDBCDriver)
> the native driver is "com.ibm.db2.jdbc.app.DB2Driver"
>
> Thanks,
> Pat.
>
> -----Original Message-----
> From: Jim Mason [mailto:JEMason@compuserve.com]
> Sent: Friday, November 09, 2001 4:13 PM
> To: INTERNET:java400-l@midrange.com
> Subject: Connecting to a remote database
>
>
> Hi.
>
> Did you create a datasource definition using the iSeries Java toolbox
> driver?  It supports remote access.  A datasource using the local DB2
> driver on iSeries won't work....
>
> Jim Mason
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.





_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.