Re: Database connection error

David,
Does it work if you use localhost instead of gobuggy?





"David Morris" <dmorris@plumcreek.com> on 28/02/2001 13:55:51

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:    (bcc: Mandy Shaw/Pacific/UK)
Subject:  Database connection error




Databaser's,

I have now been trying to locate the cause of this error for two days.  On
an AS/400 that I recently set up, I get the following message:

java.sql.SQLException: The application requester cannot establish the
connection.

I only get this error with the toolkit driver
com.ibm.as400.access.AS400JDBCDriver, not with the standard DB2 driver
com.ibm.db2.jdbc.app.DB2Driver.

I have the database host server started, and the *LOCAL database entry set
up.  This works from fine from a PC or anything attached to the AS/400, but
will not run directly on this AS/400.  I use the following with a bonafide
profile and password (it does work from another computer):
Class.forName("com.ibm.as400.access.AS400JDBCDriver").newInstance();
con = DriverManager.getConnection("jdbc:as400://gobuggy", "PROFILE",
"PASSWORD");

Thanks,

David Morris
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



      Regards,
      Mandy Shaw

      Catalyst Solutions plc
      Kingfisher House
      Frimley Business Park
      Camberley
      Surrey
      GU16 5SG
      UK

      http://www.catalyst-solutions.com
      Email: Mandy.Shaw@uk.catalyst-solutions.com

      Telephone: +44 (0)870 166 1000
      DDI: +44 870 166 1324
      Facsimile: +44 870 168 3920
      Mobile: +44 410 447966





----------------------------------------------------------------------
----------------------------------------------------------------------
Catalyst Solutions plc.  Registered No 2918101.
Registered @ Kingfisher House, Frimley Business Park, Frimley,
Surrey. GU16 5SG   U.K.

NOTICE:
This message is intended only for the named addressee(s) and may
contain confidential and/or privileged information. If you are not the
named addressee you should not disseminate, copy or take any action
or place any reliance on it. If you have received this message in error
please notify postmaster@catalyst-solutions.com and delete the message
and any attachments accompanying it immediately.
----------------------------------------------------------------------


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---