File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connect SQL2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connect SQL2000 " Watch "Connect SQL2000 " New topic
Author

Connect SQL2000

raj pat
Greenhorn

Joined: Dec 17, 2001
Posts: 4
Hi Gurus ,
Small problem.Our client want to use SQL 2000 for back end.I donn't know any efficient driver (of course free of charge or for a nominal charge) to connect the Database with my server programs (Servlets & JSP).For the development purpose I am using JDBC.ODBC driver.But I understood it is not advisable to use it for the implementation of the reall project.
Pls guide me
Rgds
Raj
Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
Microsoft is providing a JDBC driver for SQL Server 2000 that can be downloaded from their MSDN website. (According to Sun's site, they licensed the driver from Merant.) The driver is currently available in Beta 2 form at the URL http://www.microsoft.com/sql/downloads/2000/jdbc.asp. As to whether there are other drivers out there, I'd check the drivers listed on Sun's site - unfortunately, Sun's list doesn't show the version of SQL Server that the driver supports, but there are a limited set of type 3 or 4 drivers that support SQL Server, period, regardless of version.
 
Consider Paul's rocket mass heater.
 
subject: Connect SQL2000
 
Similar Threads
XML and Database
WA #1.....word association
JNDI Driver not found with Derby database connection
Why JBoss?
Anybody use a free DNS service?