java.sql.SQLException:该驱动程序不支持SQL Server版本8.SQL状态= 08S01，错误代码= 0 [英] java.sql.SQLException: SQL Server version 8 is not supported by this driver. SQL State = 08S01, Error Code = 0

问题描述

我已经将应用程序从 Websphere 6.1升级到了 Websphere 7.0 .我正在为此应用程序使用 Microsoft SQL Server jdbc驱动程序4.0 .当我使用 sqljdbc4.jar 时，连接到数据库进行身份验证时出现以下错误.

I have upgraded my application to Websphere 7.0from Websphere 6.1. I am using Microsoft SQL server jdbc driver 4.0 for this application. When i use sqljdbc4.jar i get the following error when connecting to database for authentication.

  SystemError java.sql.SQLException: SQL Server version 8 is not supported by this driver. SQL State = 08S01, Error Code = 0

如何摆脱这种情况.

推荐答案

是的，根据

JDBC驱动程序支持到SQL Azure数据库和SQL Server 2005及更高版本的连接.

The JDBC driver supports connections to a SQL Azure Database and SQL Server 2005 and later.

听起来您正在运行SQL Server 2000.

It sounds like you're running SQL Server 2000.

要么更改驱动程序(例如，升级到 jTDS )，要么升级到SQL Server的最新版本(可以大概是一个更大的任务...)

Either change driver (e.g. to jTDS) or upgrade to a more recent release of SQL Server (which would presumably be a rather bigger task...)

这篇关于java.sql.SQLException:该驱动程序不支持SQL Server版本8.SQL状态= 08S01，错误代码= 0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！