我的环境变量是这样设的:
.;c:\j2sdk1.4.2\lib\mssqlserver.jar;c:\j2sdk1.4.2\lib\msbase.jar;c:\j2sdk1.4.2\lib\msutil;c:\j2sdk1.4.2\lib\tools.jar;c:\j2sdk1.4.2\lib\dt.jar;c:\j2sdk1.4.2\jre\lib\ext;d:\cjdf\web-info\lib;
.;c:\j2sdk1.4.2\lib\mssqlserver.jar;c:\j2sdk1.4.2\lib\msbase.jar;c:\j2sdk1.4.2\lib\msutil;c:\j2sdk1.4.2\lib\tools.jar;c:\j2sdk1.4.2\lib\dt.jar;c:\j2sdk1.4.2\jre\lib\ext;d:\cjdf\web-info\lib;
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connextion con = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.33:1433;DatebaseName=DB_YHMSG","sms1","sms1sfwss");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("select * from TYHXX");
if(rs.next())
{%>
<%=rs.getString("phonenumber")%>
<%}rs.close();
stmt.close();
con.close();
%>
错误:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.bb_jsp._jspService(bb_jsp.java:76)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.bb_jsp._jspService(bb_jsp.java:54)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)