要在WEBLOGIC8.1里面支持SQL Server 2000,必须要安装Microsoft SQL Server 2000 Driver for JDBC(该程序在www.microsoft.com网站上可以下载),然后在setDomainEnv.cmd设置路径,由于我原来装的是SQL Server2000个人版的SP1,因此JDBC链接总是不成功(ODBC访问正常)。经过多次试验,才知道SQL Server2000SP1中存在一个BUG,必须要升级到SP3才行,而且还要卸载WINDOWS XP的SP2才能链接成功。
错误提示大概有如下几种,不过照以上方法都能解决:
Can’t open a socket on yesir:1433. Check host and port number and make sure the security manager allows this connection. You can also try running the SocketApplet (java.net.ConnectException: Connection refused: connect).
错误提示大概有如下几种,不过照以上方法都能解决:
Can’t open a socket on yesir:1433. Check host and port number and make sure the security manager allows this connection. You can also try running the SocketApplet (java.net.ConnectException: Connection refused: connect).