Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

SQL Server JDBC driver for websphere 6.1

 
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Rancher
Posts: 43028
76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Saloon Keeper
Posts: 25802
184
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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

 
reply
    Bookmark Topic Watch Topic
  • New Topic