下面是我的代码,我看上去它因该没有问题,各位路过的看下!
import java.sql.*;
public class Hello {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=bbs_user";
String userName = "sa";
String userPwd = "sa";
Connection dbConn;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
catch (ClassNotFoundException e) {
System.out.println("class:"+e.getMessage());
}
catch(SQLException sql){
System.out.println("sql:"+sql.getMessage()+" sTte:"+sql.getSQLState());
}
}
}异常
Microsoft Sql server 2000 Driver for JDBC ERROR establishing socket
我的sql 2000 用的是个人版的,这个错误是不是与端口有关啊,个人版的端口不是1443吗?
import java.sql.*;
public class Hello {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=bbs_user";
String userName = "sa";
String userPwd = "sa";
Connection dbConn;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
catch (ClassNotFoundException e) {
System.out.println("class:"+e.getMessage());
}
catch(SQLException sql){
System.out.println("sql:"+sql.getMessage()+" sTte:"+sql.getSQLState());
}
}
}异常
Microsoft Sql server 2000 Driver for JDBC ERROR establishing socket
我的sql 2000 用的是个人版的,这个错误是不是与端口有关啊,个人版的端口不是1443吗?
msbase.jar,
mssqlserver.jar,
msutil.jar
这三个文件,拷贝到Tomcat的\common\lib下.
==>查查打上了sql server 2000 sp2没有啊?
没有打上它就会锁住1433port的.
在CMD中,用netstat -an -p tcp看看1433port开了没?
点击开始=〉程序=〉Mocrosoft SQL Server=>Server Network Utility
把端口改为1433就行了