代码如下:
import java.sql.*;public class TestConnection{
// public static final String dbDriver = "oracle.jdbc.driver.OracleDriver"; //数据库JDBC驱动程序名称
public static String dbUrl =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"; //数据库连接URL
public static final String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; public static final String userID = "sa"; //用户ID
public static final String passwd = ""; //用户密码
private Connection ConSql() {
Connection conn ;
try {
Class.forName(dbDriver).newInstance();
conn = java.sql.DriverManager.getConnection(dbUrl,userID,passwd);
System.out.println("111111");
return conn;
} catch (Exception e) {
System.err.println("SqlBean initialization error: " +e.toString());
return null;
}
}//E
public static void main(String args[]){
TestConnection test=new TestConnection();
test.ConSql(); }
}微软的三个数据库的包也放在JDK的lib目录下.
执行结果如下:
SqlBean initialization error: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Error establishing socket.
import java.sql.*;public class TestConnection{
// public static final String dbDriver = "oracle.jdbc.driver.OracleDriver"; //数据库JDBC驱动程序名称
public static String dbUrl =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"; //数据库连接URL
public static final String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; public static final String userID = "sa"; //用户ID
public static final String passwd = ""; //用户密码
private Connection ConSql() {
Connection conn ;
try {
Class.forName(dbDriver).newInstance();
conn = java.sql.DriverManager.getConnection(dbUrl,userID,passwd);
System.out.println("111111");
return conn;
} catch (Exception e) {
System.err.println("SqlBean initialization error: " +e.toString());
return null;
}
}//E
public static void main(String args[]){
TestConnection test=new TestConnection();
test.ConSql(); }
}微软的三个数据库的包也放在JDK的lib目录下.
执行结果如下:
SqlBean initialization error: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Error establishing socket.
你安装补丁 怎么安装的?
是不是用了setup
如果是 那只是解压缩 估计你就只解压缩了
解压缩后文件夹里有个bat文件 那个才是安装文件
URL是 SQLSERVER的
你把JDBC改成SQLSERVER的再试试
com.microsoft.jdbc.sqlserver.SQLServerDriver