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.
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.
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.
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.
Joined: Feb 05, 2007
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 http://www.datadirect.com/index.html..."