This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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
It's not a secret anymore!