File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQL Server JDBC driver for websphere 6.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Server JDBC driver for websphere 6.1" Watch "SQL Server JDBC driver for websphere 6.1" New topic

SQL Server JDBC driver for websphere 6.1

Ram Kas
Ranch Hand

Joined: Jul 26, 2006
Posts: 83
Hi, I am trying to access SQL Server 2008 from application in websphere 6.1. It requires JDBC driver sqlserver.jar, base.jar, util.jar, and spy.jar. I googled extensively but did not get them. If any one has these jar files please send to me.

Thanks in advance.

Prince Manchanda
Ranch Hand

Joined: Jun 25, 2001
Posts: 52
Hi Dinakar,

I suppose you would be using the Type 4 Driver.

The jar file containing the JDBC Driver for MS SQL Server is available here:

Generally the name of the JAR file is sqljdbc.jar.

I am not sure why do you need other jar files for connecting to MS SQL Server.

Are you facing any other problem while connecting to the DB, apart from the JAR file issue that you mentioned.

Thanks and Regards
P Manchanda
Greg Stasko

Joined: Feb 05, 2007
Posts: 2

Websphere 6.1 provided the SQL Server JDBC driver from It was built in three jar files. (Base and util were common to our other JDBC drivers.) I believe that IBM has newer versions of the driver available. We've since rearchitected the drivers such that they are each in a single jar file.

Any questions...

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
Greg, who is "we" in your statement? I don't think IBM ever provided JDBC drivers for SQLServer (why would they?). Those drivers can be downloaded from Microsoft's web site, where they are pretty easily found by searching for "download SQLServer JDBC driver" or some such phrase.
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 17410

There are - or at least were - multiple sources for SQL Server drivers. At one time, the Microsoft one had been pretty useless, so I used an alternative driver from sourceforge. It was a single jar. As was the last Microsoft driver I used.

An IDE is no substitute for an Intelligent Developer.
Greg Stasko

Joined: Feb 05, 2007
Posts: 2
We = Datadirect, now part of Progress. IBM provided drivers for SQL Server because they recognized that some WebSphere App Server shops wanted to use WAS, but needed to talk to SQL Server. So IBM opted to provide a total solution.

From the above link, including the typo re "connectivy":

IBM WebSphere Connect JDBC and SequeLink JDBC Drivers


This page provides updates for JDBC drivers shipped with WebSphere Application Server to enable connectivy to the Microsoft SQL Server database.
WebSphere Connect JDBC driver
WebSphere SequeLink JDBC driver

WebSphere Application Server releases:

It's the same reason Oracle ships drivers to non-Oracle database with their App Server product.

"This chapter provides information about the WebLogic-branded DataDirect drivers that are included in the WebLogic Server installation.

Oracle provides WebLogic-branded versions of DataDirect drivers for DB2, Informix, MS SQL Server, and Sybase. Review the following sections for information on how WebLogic-branded DataDirect drivers are configured and used in a WebLogic Server environment. For detailed information on these drivers, see "Progress DataDirect for JDBC User's Guide Release 4.2" and "Progress DataDirect for JDBC Reference Release 4.2" at"

I agree. Here's the link:
subject: SQL Server JDBC driver for websphere 6.1
It's not a secret anymore!