sqlserver 2000sp4补丁jdbc驱动 三个文件包也拷贝了 可就是联不上 sqlserver2000提示:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
请教大家!
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
请教大家!
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;public class DBConnection_mssql {
private final static String DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver" ;
private final static String Url="jdbc:microsoft:sqlserver://192.168.0.13:1433;Database=t001";
private final static String Name="sa";
private final static String Pass="123456";
private static Connection conn=null;
private ResultSet result=null;
private PreparedStatement pst;
public static Connection getConnection(){
try {
Class.forName(DriverName);
conn=DriverManager.getConnection(Url, Name, Pass);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
conn=DBConnection_mssql.getConnection();
System.out.println(conn.toString());
}
}