jsp and SQl

Hi Friends

I started one project in jsp and SQL server but problem is when i installed tomcat on windows XP with SP2 it give error

"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:193)

at DB.Test.<init>(Test.java:27)

at DB.Test.main(Test.java:62) "

please suggest me because it work fine when i run same code in windows NT or windows 2000 server

Dhiraj-redox

[1206 byte] By [dhiraj-redoxa] at [2007-11-27 10:45:32]
# 1

JSP and SQL. Oh my.

cotton.ma at 2007-7-28 20:13:30 > top of Java-index,Java Essentials,Java Programming...
# 2

Hi,

There have been cases reported using JDBC driver provided by microsoft.I personally had one.

I solved it by changing the JDBC driver from one provided by microsoft to jtds.

http://jtds.sourceforge.net/

Hope tht might help :)

REGARDS,

RaHuL

RahulSharnaa at 2007-7-28 20:13:30 > top of Java-index,Java Essentials,Java Programming...