Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server JDBC driver for websphere 6.1

 
Ram Kas
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Dinakar.K
 
Prince Manchanda
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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: http://www.microsoft.com/en-in/download/details.aspx?id=11774.

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.
 
Greg Stasko
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Everyone,

Websphere 6.1 provided the SQL Server JDBC driver from datadirect.com. 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...

Greg
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 18162
53
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Greg Stasko
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

ftp://ftp.software.ibm.com/software/websphere/info/tools/DataDirect/datadirect.htm

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

IBM WebSphere Connect JDBC and SequeLink JDBC Drivers

Abstract

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
Applicability

WebSphere Application Server releases:
6.1.0.x
6.0.2.x
5.1.1.x

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 http://www.datadirect.com/index.html..."

http://docs.oracle.com/cd/E28280_01/web.1111/e13726/dd.htm

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic