Thank you very much.  I will get back to this as soon as I can...
unfortunately we installed a CAE Licensed program last night and now cannot
sign on to that machine...  :-(

Joel R. Cochran
Director of Internet Services
VamaNet.com
(800)480-8810
mailto:webmaster@vamanet.com


> -----Original Message-----
> From: Dieter.Bender@t-online.de [mailto:Dieter.Bender@t-online.de]
> Sent: Wednesday, June 12, 2002 5:38 AM
> To: java400-l@midrange.com
> Subject: Re: AW: OF: what is websphere (locate Tomcat)
>
>
> Joel,
>
> - the machine with the database you want to access needs an
> entry with a name
> and under IP adress you will see *LOCAL
> - with the toolbox driver AS400JDBCDriver.class you use the
> IP adress or a
> name wich can be resolved to an IP adress by Domain Name
> Services or an entry
> to the Hosts table of the client; this driver works from all
> systems to
> access a DB2/400 database.
> - with the native driver (subprotocol db2) you can connect
> from an as400 to
> any other system with db2 connect, you need an entry with
> *local for the
> local machine and an entry with communication resolution for
> a remote system.
> You use the name from the RDBDIR for the connect, not the ip adress.
>
> If this doesn't solve your problem, it would be best to
> provide some code and
> the exact error messages you get and then we can fix it together.
>
> Dieter
>
> Am Dienstag, 11. Juni 2002 23:15 schrieben Sie:
> > I have an entry, but it lists the system name and not the
> IP address.  I
> > understand from other posts that if the driver is the
> native db2 driver
> > that I need to refer to the configured name instead of the
> IP, but I am not
> > using the db2 driver, i am using the
> > "com.ibm.as400.access.AS400JDBCDriver".  The problem is I
> don't know how to
> > proceed next.
> >
> > Thanks,
> >
> > Joel R. Cochran
> > Director of Internet Services
> > VamaNet.com
> > (800)480-8810
> > mailto:webmaster@vamanet.com
> >
> > > -----Original Message-----
> > > From: MEovino@estes-express.com [mailto:MEovino@estes-express.com]
> > > Sent: Tuesday, June 11, 2002 5:07 PM
> > > To: java400-l@midrange.com
> > > Subject: RE: AW: OF: what is websphere (locate Tomcat)
> > >
> > >
> > >
> > > What seems to be the problem with it?
> > >
> > > Mike E.
> > >
> > >
> > >
> > >
> > >
> > >                     "Joel R. Cochran"
> > >                     <jrc@masi-brac.com       To:
> > > "'java400-l@midrange.com'" <java400-l@midrange.com>
> > >
> > >                     >                        cc:
> > >
> > >                     Sent by:                 Subject:     RE:
> > > AW: OF: what is websphere (locate Tomcat)
> > >                     java400-l-admin@mi
> > >                     drange.com
> > >
> > >
> > >                     06/11/2002 03:50
> > >                     PM
> > >                     Please respond to
> > >                     java400-l
> > >
> > >
> > >
> > >
> > >
> > >
> > > It got me one step farther, but now I'm struggling with
> the RDBDIRE
> > >
> > >
> > > Joel R. Cochran
> > > Director of Internet Services
> > > VamaNet.com
> > > (800)480-8810
> > > mailto:webmaster@vamanet.com
> > >
> > > > -----Original Message-----
> > > > From: MEovino@estes-express.com
> [mailto:MEovino@estes-express.com]
> > > > Sent: Tuesday, June 11, 2002 3:36 PM
> > > > To: java400-l@midrange.com
> > > > Subject: RE: AW: OF: what is websphere (locate Tomcat)
> > > >
> > > >
> > > >
> > > > Joel,
> > > >
> > > > Did Dieter's suggestion work?
> > > >
> > > > Mike E.
> > > >
> > > >
> > > >
> > > >
> > > >                     "Joel R. Cochran"
> > > >                     <jrc@masi-brac.com       To:
> > > > "'java400-l@midrange.com'" <java400-l@midrange.com>
> > > >
> > > >                     >                        cc:
> > > >
> > > >                     Sent by:                 Subject:     RE:
> > > > AW: OF: what is websphere (locate Tomcat)
> > > >                     java400-l-admin@mi
> > > >                     drange.com
> > > >
> > > >
> > > >                     06/11/2002 03:14
> > > >                     PM
> > > >                     Please respond to
> > > >                     java400-l
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > It is there, but my Java code specifies the access by IP
> > > > address.  Do I
> > > > need
> > > > to change the Java code or WRKRDBDIRE?
> > > >
> > > > Joel R. Cochran
> > > > Director of Internet Services
> > > > VamaNet.com
> > > > (800)480-8810
> > > > mailto:webmaster@vamanet.com
> > > >
> > > > > -----Original Message-----
> > > > > From: MEovino@estes-express.com
> [mailto:MEovino@estes-express.com]
> > > > > Sent: Tuesday, June 11, 2002 2:56 PM
> > > > > To: java400-l@midrange.com
> > > > > Subject: RE: AW: OF: what is websphere (locate Tomcat)
> > > > >
> > > > >
> > > > >
> > > > > I'm jumping into this late and haven't read the whole thread,
> > > > > so forgive me
> > > > > if this doesn't have anything to do with your post.  But it
> > > > > looks like you
> > > > > need to check the Relational Database Directory entries.
> > > > >
> > > > > Enter WRKRDBDIRE from the command line.  You should at
> > > >
> > > > least see this:
> > > > >                Work with Relational Database Directory Entries
> > > > >
> > > > > Position to  . . . . . .
> > > > >
> > > > > Type options, press Enter.
> > > > >   1=Add   2=Change   4=Remove   5=Display details
> > >
> > > 6=Print details
> > >
> > > > >         Relational          Remote
> > > > > Option  Database            Location                  Text
> > > > >
> > > > >         YOURMACHINENAME     *LOCAL                    Entry
> > > > > added by system
> > > > >
> > > > > If you don't see that, add your local machine.  If you
> > >
> > > are trying to
> > >
> > > > > contact another 400, add an entry for that machine as well.
> > > > >
> > > > > Hope that helps.
> > > > >
> > > > > Mike E.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >                     "Joel R. Cochran"
> > > > >                     <jrc@masi-brac.com       To:
> > > > > "'java400-l@midrange.com'" <java400-l@midrange.com>
> > > > >
> > > > >                     >                        cc:
> > > > >
> > > > >                     Sent by:                 Subject:     RE:
> > > > > AW: OF: what is websphere (locate Tomcat)
> > > > >                     java400-l-admin@mi
> > > > >                     drange.com
> > > > >
> > > > >
> > > > >                     06/11/2002 02:39
> > > > >                     PM
> > > > >                     Please respond to
> > > > >                     java400-l
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Thanks Dieter, I got that one fixed.  But now when I try to
> > > > > connect I get
> > > > > the message "Relational database xxx.xxx.xxx.xxx not in
> > > > > relational database
> > > > > directory."
> > > > >
> > > > > What the heck is the "relational database directory"?
> > > > >
> > > > > Joel R. Cochran
> > > > > Director of Internet Services
> > > > > VamaNet.com
> > > > > (800)480-8810
> > > > > mailto:webmaster@vamanet.com
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Dieter.Bender@t-online.de
> > >
> > > [mailto:Dieter.Bender@t-online.de]
> > >
> > > > > > Sent: Tuesday, June 11, 2002 2:15 PM
> > > > > > To: java400-l@midrange.com
> > > > > > Subject: Re: AW: OF: what is websphere (locate Tomcat)
> > > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > put the jt400.jar in the lib directory under tomcat
> directory
> > > > > > WEB-INF, as you
> > > > > > would do it in any other Tomcat installation
> > > > > >
> > > > > > Dieter
> > > > > >
> > > > > > Am Dienstag, 11. Juni 2002 18:14 schrieben Sie:
> > > > > > > I've gotten Tomcat installed and running as an Apache
> > > > > >
> > > > > > in-process server on
> > > > > >
> > > > > > > my 270.I have written my own servlet, compiled it, and
> > > > > >
> > > > > > moved it to my
> > > > > >
> > > > > > > WEB-INF directory.
> > > > > > >
> > > > > > > The page (which is found and does produce output) is
> > > > > >
> > > > > > supposed to connect to
> > > > > >
> > > > > > > the 400's database, but it cannot find the
> > > > > > > "com.ibm.as400.access.AS400JDBCDriver" class.  I'm sure
> > > > > >
> > > > > > this is a classpath
> > > > > >
> > > > > > > issue, but how do I set the classpath on the 400,
> > > > > >
> > > > > > preferably a one time
> > > > > >
> > > > > > > deal like setting environment variables in Win2000.  Also,
> > > > > >
> > > > > > does anyone know
> > > > > >
> > > > > > > where this little gem lives in the IFS?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > Joel R. Cochran
> > > > > > > Director of Internet Services
> > > > > > > VamaNet.com
> > > > > > > (800)480-8810
> > > > > > > mailto:webmaster@vamanet.com
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > 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.
> > > > > >
> > > > > > --
> > > > > > mfG
> > > > > >
> > > > > > Dieter Bender
> > > > > >
> > > > > >
> > > > > > DV-Beratung Dieter Bender
> > > > > > Wetzlarerstr. 25
> > > > > > 35435 Wettenberg
> > > > > > Tel. +49 641 9805855
> > > > > > Fax +49 641 9805856
> > > > > > www.bender-dv.de
> > > > > >
> > > > > > _______________________________________________
> > > > > > 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.
> > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > 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.
>
> --
> mfG
>
> Dieter Bender
>
>
> DV-Beratung Dieter Bender
> Wetzlarerstr. 25
> 35435 Wettenberg
> Tel. +49 641 9805855
> Fax +49 641 9805856
> www.bender-dv.de
>
> _______________________________________________
> 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.
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.