JSP无法连接到SQLServer????
[Microsoft][SQLServer JDBC Driver]Error establishing socket.
:: SQL
我的代码如下
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}catch(ClassNotFoundException e){out.print(e.getMessage()+"<br>");}
try
{
con=DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","123456");
sql=con.createStatement();
out.print("yes<p>");
rs=sql.executeQuery("SELECT * FROM stores");
%>
<%
while(rs.next())
{
out.print(rs.getString(3));
out.print("<br>");
}
}catch(SQLException e){out.print(e.getMessage()+" <br>:: SQL");}
catch(Exception e){ out.print(e.getMessage());}
%>
</body>
</html>
我的运行结果如下:
[Microsoft][SQLServer JDBC Driver]Error establishing socket.
:: SQL
我已经安装了Microsoft SQL Server 2000 driver for JDBC并将
msbase.jar ,msutil.jar ,mssqlserver.jar 这三个文件的路径包含到CLASSPATH中并且已经复制到%JAVA_HOME%/jre/lib/ext中.
但还是发生的错误
SQLServer已经启动了,而且我通过其带的那个Server Network Utility工具查到其TCP/IP用的是1433端口,但不知为什么通过netstat -a看不到有这个端口
不知道是什么原因??