Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP, SQLServer2000 and TomCat

 
Gayathri Neti
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a question. Is JSP compatible with SQLServer2000 on TomCat?
What are the JDBC drivers that I need?
Do I need any third party software to make these three work??
Thanks.
 
Navi Singh
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
jdbc-odbc bridge should solve your problem.
But if u r not using the bridge,i think the drivers updates come along with the sql-server update version.
It really should not make any difference to tomcat
as long as the interface is coded properly.
 
RAJESH RASTOGI
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,
use this driver provided by sun in Class.forName method in the following way -
Class.forName( "sun.com.JdbcOdbcDriver" )
hope it will help u
 
Gopi Balaji
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Gayathri Neti:
Hi,

I have a question. Is JSP compatible with SQLServer2000 on TomCat?
What are the JDBC drivers that I need?
Do I need any third party software to make these three work??
Thanks.

Microsoft itself has a JDBC driver for SQL Server 2000. It is a free download available at - http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml
-GB.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic