把sqlserver2000的jdbc驱动复制到你的应用的WEB-INF\lib目录下(lib目录不存在就创建它)
解决方案 »
- Heritrix运行时出错,登陆webUI出错,求救!
- httpClient 如何获取页面传来特定的字符串????
- jsp
- jfreechart图表保存成jpg文件出错,求救!
- 为什么 the useBean class attribute javazoom.upload.UploadBean is invalid.
- 关于通过连接池从oracle数据库读取大对象的问题?在线等!!!
- 打开jsp页面出现错误,谁能帮我!
- 请教大侠,如果在jsp中调用excal里面的图表控件,在网页上显示图表!万分感谢!
- 求教:在servlet中设定的cookie,为何在jsp中得不到值,但在别的servlet中能得到?
- jsp博客系统相册功能模块
- 请问html中select能否编辑,具体见内容
- 大家是怎么在weblogic下调试的??
不过,又出现了另一个问题。我写了如下代码:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DataBase=Northwind"; Connection con=DriverManager.getConnection(url,"sa","我的密码");
Statement stm=con.createStatement();
ResultSet rs=stm.executeQuery("select Title from Employees");
while(rs.next())
{
out.println (rs.getString(1)+"\t");
}
rs.close();
stm.close();
con.close();报错:javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
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.(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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)是不是我的sqlserver哪里还需要设置?我是新手,请大虾们指教。