Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") ;
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.200.125.14:1433",user,password);
Statement stmt = conn.createStatement() ;
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.200.125.14:1433",user,password);
Statement stmt = conn.createStatement() ;
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433",user,password);
Statement stmt = conn.createStatement() ;
推荐使用JDK1。4的版本
使用ODBC-JDBC-DRIVER连接就正常了至于驱动吗,在控制面版里面有一个ODBC 32位连接器,就是这个
2 try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:DatabaseName",user,password);
Statement stmt = conn.createStatement() ;
}
catch(ClassNotFoundException e)
{
}
3 jdk1.4中自带ODBC-JDBC-DRIVER。
其实现在驱动也装好了,安装路径是C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib,所以我的classpath为
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
但还是没用,错误描述是ClassNotFoundException