Oh, sorry didnt read the email close enough. We only use
iSeries db2 but looking at the web it seems that
db2java.zip
has a major part but dont know the settings.
Good luck and sorry couldnt be more help.
Don
----------------------------------------
From: MKirkpatrick@xxxxxxxxxxxxxxxxx
Sent: Tuesday, June 12, 2007 9:52 AM
To: Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Quantum DB connection to DB2 in Windows
Thanks Don, But......
I have the connection to my system i up and working just as you describe.
What I am looking to do is to connect to a DB2 data base on my WINDOWS
platform. Have you done this at all?
Thanks.
Michael Kirkpatrick
Western Dental Services, Inc.
Information Systems
(
Phone:
(714) 571.3582
(
Toll free:
(800) 471.4444
7
Fax:
(714) 480.3001
*
Email:
mkirkpatrick@xxxxxxxxxxxxxxxxx
8
Web:
http://www.westerndental.com/
"dnitke"
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
06/12/2007 08:56 AM
Please respond to
Websphere Development Studio Client for iSeries
To
cc
Subject
Re: [WDSCI-L] 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
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.
midrange.com
