import java.sql.*;
public class ConnJdbcOdbc{
public static void main(String[] arguments){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=
DriverManager.getConnection("jdbc:odbc:northwind","sa","");
TryDirectConnection();
}catch(Exception e){
System.out.print(e.toString());
}
}
static void TryDirectConnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind","sa","");
//how to set timeout
}catch(Exception e){
System.out.print(e.toString()+" 2 ");
}
}
}
错误信息为:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. 2 也就是说第一个 连接成功,第二个连接失败,还请教是什么原因
public class ConnJdbcOdbc{
public static void main(String[] arguments){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=
DriverManager.getConnection("jdbc:odbc:northwind","sa","");
TryDirectConnection();
}catch(Exception e){
System.out.print(e.toString());
}
}
static void TryDirectConnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind","sa","");
//how to set timeout
}catch(Exception e){
System.out.print(e.toString()+" 2 ");
}
}
}
错误信息为:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. 2 也就是说第一个 连接成功,第二个连接失败,还请教是什么原因
你的SQL Server是不是没打sp3补丁?
另:我没有发现设置连接超时,不知道JAVA中没有这个概念
估计是你SQL验证方面的问题,你把你的SQL验证改为混合验证方式,在试验一下。