File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes DB2 connection without the client Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "DB2 connection without the client" Watch "DB2 connection without the client" New topic

DB2 connection without the client

M Givney

Joined: Sep 24, 2003
Posts: 25
Is it possible to connect to a DB2 database server in WSAD without having the DB2 client on my machine?

I just want to connect to a database thru my jdbc driver. Is it possible? If not, does anyone know if you can get a linux copy of the client for free?

Kyle Brown
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
DB2 does have a NET (type-4) driver that does not require DB2 Connect, yes. I'm not sure if there's a free Linux version or not. See more information on the DB2 drivers here:


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at for other WebSphere information.
Prakash Dwivedi
Ranch Hand

Joined: Sep 28, 2002
Posts: 452
Hello Kyle,

I am also having similar problem. I have to connect to DB2 database which is on remote machine and i dont have db2 client. I have downloaded Type 4 Third Party Driver , but my problem is that when i create JDBC Provider in WSAD, what JDBC- Provider Type should i choose??

Because when i choose "DB2 JDBC Provider" or something else i dont get any "JDBC Provider" displayed while creating Data Source.

Plz Help

[ May 21, 2004: Message edited by: Prakash Dwivedi ]

Prakash Dwivedi (SCJP2, SCWCD, SCBCD)
"Failure is not when you fall down, Its only when you don't get up again"
M Givney

Joined: Sep 24, 2003
Posts: 25

From a link off of the link Kyle provided from IBM, I read that the DB2 Net (Type4) driver only works with DB2 version 8.

So because we use v7.2, I guess I will need to install the client....curses!

Thanks for the assist Kyle!
I agree. Here's the link:
subject: DB2 connection without the client