现在系统重做后,安装新的XP系统,在配置jbuilder2005与sql2000时老是出错,请问错在那里,万分感激!
我的步骤是:
1;Tools->Configure->Libraries里,用下面的New 新建一个"sql2000jdbc",并选种User Home里.然后Add,安装好的一个SQL2000 driver for java中lib目录里的3个jar文件
2:Enterprise->Enterprise Setup->Database Drivers->Add->"User Home里刚才在步骤一里"sql2000jdbc".
3:Tools->Database pilot->View->Options->Drivers->Add->"com.microsoft.jdbc.sqlserver.SQLServerDriver",在Sample URL里填写"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=wuhan",然后新建一个数据库连接,输入用户名和密码
就会报如下错误:
会弹出对话框: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
然后stack Track里有如下错误,请问是我的那步操作 有问题:
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) at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source) at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source) at com.borland.jdbcx.metadata.d.run(Unknown Source)
我的步骤是:
1;Tools->Configure->Libraries里,用下面的New 新建一个"sql2000jdbc",并选种User Home里.然后Add,安装好的一个SQL2000 driver for java中lib目录里的3个jar文件
2:Enterprise->Enterprise Setup->Database Drivers->Add->"User Home里刚才在步骤一里"sql2000jdbc".
3:Tools->Database pilot->View->Options->Drivers->Add->"com.microsoft.jdbc.sqlserver.SQLServerDriver",在Sample URL里填写"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=wuhan",然后新建一个数据库连接,输入用户名和密码
就会报如下错误:
会弹出对话框: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
然后stack Track里有如下错误,请问是我的那步操作 有问题:
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) at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source) at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source) at com.borland.jdbcx.metadata.d.run(Unknown Source)
有防火墙?
急 急!
急了几天了,还是出下面的错误。有没有 大侠 遇到这样的问题?
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) at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source) at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source) at com.borland.jdbcx.metadata.d.run(Unknown Source)
2,在你的工程属性里加上你的sqljdbc库了吗?
======================================================================================
C:\JBuilder2005\jdk1.4\bin\javaw -classpath "E:\work\db\classes;E:\SQLserver-JDBC-Driver\msbase.jar;E:\SQLserver-JDBC-Driver\mssqlserver.jar;E:\SQLserver-JDBC-Driver\msutil.jar;C:\JBuilder2005\jdk1.4\jre\javaws\javaws.jar;C:\JBuilder2005\jdk1.4\jre\lib\charsets.jar;C:\JBuilder2005\jdk1.4\jre\lib\ext\dnsns.jar;C:\JBuilder2005\jdk1.4\jre\lib\ext\ldapsec.jar;C:\JBuilder2005\jdk1.4\jre\lib\ext\localedata.jar;C:\JBuilder2005\jdk1.4\jre\lib\ext\sunjce_provider.jar;C:\JBuilder2005\jdk1.4\jre\lib\im\indicim.jar;C:\JBuilder2005\jdk1.4\jre\lib\im\thaiim.jar;C:\JBuilder2005\jdk1.4\jre\lib\jce.jar;C:\JBuilder2005\jdk1.4\jre\lib\jsse.jar;C:\JBuilder2005\jdk1.4\jre\lib\plugin.jar;C:\JBuilder2005\jdk1.4\jre\lib\rt.jar;C:\JBuilder2005\jdk1.4\jre\lib\sunrsasign.jar;C:\JBuilder2005\jdk1.4\lib\dt.jar;C:\JBuilder2005\jdk1.4\lib\htmlconverter.jar;C:\JBuilder2005\jdk1.4\lib\tools.jar" db1.Test
类实例化成功!
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)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at db1.Test.main(Test.java:19)
我的机器是XP Professional sp2,个packs都打齐了.
解决方法:
1:要安装 驱动microsoft sqlserver 2000 driver for JDBC service packs 3
2:要对microsoft sqlserver2000数据库进行SP4补丁升级,网址是:http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5。
有3个packs 要安装,其中有2个是点击安装文件后提示 C:\SQL2KSP4,然后要我手工在里面点击setup安装。 ( 回复人:chouhouhi() 看你的问题是不是出在这,以为系统安装了,实际没有装上去)
3:按照我首题里的配置步骤配置一便。
ph09227(闯月) :经过你的提醒,问题的确是这样;我把升级包直接安装上了;呵呵;
不过我只安装了一个包SQL2000-KB884525-SP4-x86-CHS;问题就解决了;
另外两个都不能安装,
一个提示说需要安装Analysis Service200;
另一个提示:指定的实例名无效;