用jdbc连接sql server2008总是出现No suitable driver found for jdbc:sqlserver://localhost:1368;DatabaseName=gdut_lib;SelectMethod=Cursor错误,因为是做课程设计,要在myEclipse中建项目。dbClassName = "sun.jdbc.odbc.JdbcOdbcDriver";
我把同样的代码写在了eclipse中,惊奇地发现能顺利连接上,后来改为dbClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";在myEclipse和eclipse中都能顺利连上
注意,2005和2008是用dbClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver",看好了,不是用
dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
驱动选用sqljdbc4.jar