MS SQL2000 (Error establishing socket)错误的解决办法-SQL请选用混和安装模式
<script language="JavaScript" type="text/JavaScript"></script>
<script type="text/javascript">
</script><script type="text/javascript"> </script>
- -----------------------------------------------------------------------------------------
* Error: get DB connection error. Ex. msg: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
---------------------------------------------------------------
无法建立数据库连接,
确定网络没有问题
SQL有开着,
把SQL打到SP3的补丁
驱动也要对应SP3的.
---------------------------------------------------------------
1、下载Microsoft SQL Server 2000 Service Pack 3a并安装,SQL请选用混和安装模式!!!
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn
2、下载SQL Server 2000 Driver for JDBC Service Pack 3
http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en
3、运行时关闭防火墙 4.telnet 127.0.0.1 1433 检查mssql端口是否正常