用com.microsoft.jdbc.sqlserver.SQLServerDriver这个驱动时,报以下错误(时报时不报):
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data conversion.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The operation was cancelled at the user's request.
如果把驱动改为sun.jdbc.odbc.JdbcOdbcDriver,则正常,没有什么错误
为什么?请转到这个贴子上: http://community.csdn.net/Expert/TopicView3.asp?id=4588841
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data conversion.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The operation was cancelled at the user's request.
如果把驱动改为sun.jdbc.odbc.JdbcOdbcDriver,则正常,没有什么错误
为什么?请转到这个贴子上: http://community.csdn.net/Expert/TopicView3.asp?id=4588841
jdbc驱动的版本多少?推荐楼主升级sql到sp4
然后到microsoft下载一个最新的jdbc驱动,这个驱动可以支持到sql server 2005这样问题应该解决了
C:\Java\jdk1.5.0_05\jre\lib\ext
C:\Java\jre1.5.0_05\lib\ext
具体的视你的安装目录而定。但是一定要在JDK和JRE两个下面的ext目录中都放三个jar文件。一个是编译用,一个是运行用。
三个jar文件应该是:mssqlserver.jar, msutil.jar, msbase.jar