Dave Mann wrote on 25/04/2007 10:56:36:
Here's the connection URL "jdbc:odbc:COR400"
The driver I am using is the JDBC ODBC Bridge.
Hmm ... same thing happens for me when I use this driver. I'd recommend
using the JT400 JDBC driver (this is provided with WDSC), unless you have
a specific reason to use the other driver. I'm not sure why it worked
before, but not now. Perhaps something to do with the Quantum version
change?
At any rate, in order to use the JT400 driver, do the following:
1. In the Quantum Bookmarks view, choose "New Bookmark".
2. In the New Bookmark dialogue, click the "Add driver" button
3. In the New JDBC Driver dialogue, click the "Add External Jar" button
4. In the Open dialogue, navigate to
<path-to-WDSCi-install>/SDP70Shared/plugins/com.ibm.iseries.toolbox_7.0.0.v200702012355/runtime
5. Still in the Open dialogue, double click the file "jt400.jar"
6. Back in the New JDBC Driver dialogue, click the "Browse" button beside
the "Class name:" textbox.
7. In the Select a Driver dialogue, select "
com.ibm.as400.access.AS400JDBCDriver"
8. Back in the New JDBC Driver dialogue, click the "Finish" button.
9. Back in the New Bookmark dialogue, select the newly added "AS400
Toolbox for Java JDBC Driver" entry. Click "Next".
10. On the next page of the New Bookmark dialogue, Enter your username and
password, and use "jdbc:as400://<server IP or DNS name>" as the JDBC URL.
There are other options you can use here, seperated by semicolons. See
the documentation for the JDBC toolbox in the InfoCentre for details. Some
common options for Quantum users are "libraries=*libl;" and
"naming=system;".
11. Still in the New Bookmark dialogue, click "Finish"
Hope this helps,
Adam
Attention:
The information contained in this message and or attachments is
intended only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient is
prohibited. If you received this message in error, please contact the sender
and
delete the material from any system and destroy any copies. Thank you for your
time and consideration.
Attention:
Le contenu de ce message et(ou) les fichiers ci-joints s?adressent
exclusivement à la personne ou -entité à laquelle ils sont destinés. Ils
peuvent
contenir de l?information confidentielle, protégée et(ou) classifiée. Il est
strictement interdit à toute personne ou entité autre que le(la) destinataire
prévu(e) de ce message d?examiner, de réviser, de retransmettre ou de diffuser
cette information, de prendre une quelconque action en fonction ou sur la base
de celle-ci, ou d?en faire tout autre usage. Si vous avez reçu ce message par
erreur, veuillez communiquer avec l?expéditeur(trice), supprimer ce message et
les fichiers ci-inclus de tout système, et en détruire toutes copies, qu?elles
soient électroniques ou imprimées. Nous vous remercions de votre entière
collaboration.
midrange.com
