wood burning stoves 2.0*
The moose likes JDBC 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
Bookmark "SQL Server JDBC driver for websphere 6.1" Watch "SQL Server JDBC driver for websphere 6.1" New topic
Author

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.

Dinakar.K
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: 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.


Thanks and Regards
P Manchanda
Greg Stasko
Greenhorn

Joined: Feb 05, 2007
Posts: 2
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
Marshal

Joined: Mar 22, 2005
Posts: 42061
    
  64
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.


Ping & DNS - my free Android networking tools app
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16103
    
  21

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.


Customer surveys are for companies who didn't pay proper attention to begin with.
Greg Stasko
Greenhorn

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.

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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server JDBC driver for websphere 6.1