Re: Quantum DB connection to DB2 in Windows

[MKirkpatrick@xxxxxxxxxxxxxxxxx]

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" <dnitke@xxxxxxxxxxxxxxx> 
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
06/12/2007 08:56 AM
Please respond to
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>


To
<wdsci-l@xxxxxxxxxxxx>
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 <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.