Re: Quantum DB connection to DB2 in Windows

Michael,

The type is:
DB2 for AS400

Driver Jar is:
JT400.jar (can be found in client access folder but be careful its not too old.
Might want to download it from IBM's Java toolbox site)

Class Name is:
com.ibm.as400.access.AS400JDBCDriver (only one available for selection when
JT400 is pointed to

Connection URL is:
jdbc:as400://youriSeries;libraries=myLib

youriSeries is of course your system name while myLib is the filtered single
library. You can have multiple by putting comma's in betwee the names I believe.

Hope this helps
Don N.

----------------------------------------

From: MKirkpatrick@xxxxxxxxxxxxxxxxx
Sent: Monday, June 11, 2007 1:18 PM
To: Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Quantum DB connection to DB2 in Windows

I am trying to access a DB2 database in Windows. I am not even sure what
JDBC drive to use and where to find it.

My system i connection works great.

Thanks.

Jeff Young
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
06/11/2007 12:16 PM
Please respond to
Websphere Development Studio Client for iSeries

To
Websphere Development Studio Client for iSeries
cc

Subject
Re: [WDSCI-L] Quantum DB connection to DB2 in Windows

Mike,
Are you looking for the url to access the System i5 or windows?

Thanks,

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3

----- Original Message ----
From: "MKirkpatrick@xxxxxxxxxxxxxxxxx"
To: Websphere Development Studio Client for iSeries
Sent: Monday, June 11, 2007 1:05:57 PM
Subject: [WDSCI-L] Quantum DB connection to DB2 in Windows

Has anyone created a Database Bookmark using the Quantum DB plug-in to
access a DB2 database in the Windows environment?

If so, would you please share the JDBC driver used, where you got the
driver, driver path and the specific connection URL string. Also, were
there any specific changes needed in the CLASSPATH environment variable to

do this?

Thanks so much.

michael

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Unless you are the addressee (or authorized to receive for the
addressee), you may not use, copy or disclose to anyone this email or any
information contained in this email. If you have received this email in
error, please advise the sender by replying to this email, and delete this
email immediately. Please note that any views or opinions presented in
this email are solely those of the author and do not necessarily represent
those of Western Dental Services, Inc. Finally, the recipient should
check this email and any attachments for the presence of viruses. Western
Dental Services, Inc. accepts no liability for any damage caused by any
virus transmitted by this email.