jdbc 连接sql2000问题
cpine 2008-09-27 03:19:23 我在使用JDBC连接数据库SQL2000的时候出现在这样的错误
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:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.lhhx.demo.DataConnection.main(DataConnection.java:16)
程序代码如下,我用的是ECLIPSE
import java.sql.*;
public class DataConnection {
public static void main(String[] args) throws InstantiationException, IllegalAccessException {
String DataDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";
String user="sa";
String password="aptech";
try {
Class.forName(DataDriver).newInstance();
System.out.println("数据库已经连接");
try {
Connection conn=DriverManager.getConnection(url, user, password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String sql="insert into Region values ('admin')";
int n=stmt.executeUpdate(sql);
if (n>0)
{
System.out.println("数据插入成功");
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}