Help with JDBC and SQL Connecting to AS400 ISERIES and DB2

Thread view:

LightSquire@gmail.com - 20 Dec 2006 16:49 GMT

I have found Sql Squirrel on Sourceforge, and have been trying to get
it to work, I downloaded JTOPEN 5.3 and added the jt400 jar files to
the IBM DB2 App Driver and IBM DB2 Net driver. The problem I have being
new to this is how to I tell this software what my as400 is?

I see where i nthe Db2 App driver wants the url jdbc:db2:<dbname>, or
the Net Driver with jdbc:db2://<server>:<6789>/<db-name ?

Can anyone offer me some guidence?

I just started in a small shop with almost no tools and I am trying to
get them to adopt Websphere, as well and some other useful tools of
which this looks great but I am not that experienced with jdbc.

Thanks
Shadow

Reply to this Message

LightSquire@gmail.com - 21 Dec 2006 13:58 GMT

> I have found Sql Squirrel on Sourceforge, and have been trying to get
> it to work, I downloaded JTOPEN 5.3 and added the jt400 jar files to
[quoted text clipped - 12 lines]
> Thanks
> Shadow

I found the answer...boy do I have a lot to learn...thanks to all for
the emails.

Shadow

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...