Re: Quantum DB connection to DB2 in Windows

I have configured QuantumDB plug-in to access a DB2 database residing on
Windows.

The type is:
DB2

Driver Jar is:
db2jcc.jar (can be found in C:\Program
Files\IBM\SDP70Shared\plugins\com.ibm.datatools.db2_1.0.0.v200607211720\driver\db2jcc.jar)


You also need the following added as external JARs C:\Program
Files\IBM\SDP70Shared\plugins\com.ibm.datatools.db2_1.0.0.v200607211720\driver\db2jcc_license_cu.jar;C:\Program

Files\IBM\SDP70Shared\plugins\com.ibm.datatools.db2_1.0.0.v200607211720\driver\db2jcc_license_cisuz.jar)

Class Name is:
com.ibm.db2.jcc.DB2Driver

Connection URL is:
jdbc:db2://servername:50000/databasename

Hope this helps others using the QuantumDB plug-in.

Regards.

__________________

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 <cooljeff913@xxxxxxxxx>
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
06/11/2007 12:16 PM
Please respond to
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>


To
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
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" <MKirkpatrick@xxxxxxxxxxxxxxxxx>
To: Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
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.