jdbc就是连接不上sqlserver
用jdbc连接sqlserver,就是连不上,baidu/google过很多相关资料,也没有结果.
用jbuilder x编译通过,运行过程中驱动程序已经加载成功,但连接数据库总是失败.
192.168.0.23是我在局域网中的固定ip,sqlserver2000服务管理器正常运行,程序中要连接的数据库名就是sqlserver2000自带的pubs数据库.
我试过吧192.168.0.23换成过localhost和服务器名都不行,请求解答.此前用jdbc-odbc桥成功连接.
主要代码如下:
public class jdbctest{
Connection con;
String url="jdbc:microsoft:sqlserver://192.168.0.23:1433;DatabaseName=pubs";
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
public static void main(){
try{ // load driver
Class.forName(driver);
System.out.println("Driver successfully loaded.");
} catch(Exception e){
System.out.println("driver load failed.");
}
try{ // connect database
con = DriverManager.getConnection(url,"sa","cx");
System.out.println("Database successfully connected.");
}catch(Exception e){
System.out.println("connect failed.");
}
}//end main
}
问题点数：20、回复次数：7Top
1 楼hskflyin（小海）回复于 2006-03-19 20:01:45 得分 0
main()中漏参数,不是此错误.Top
2 楼tygker（）回复于 2006-03-19 21:55:56 得分 4
驱动程序已经加载成功,那最有可能的就是登陆的用户名和密码错了,sql server 有两种登陆方式,要把它改成sql server 和windows 混合模式才可以用sa用户登陆.Top
3 楼carwen（卡文）回复于 2006-03-19 22:03:51 得分 4
恩
可能是用户登陆方式的问题
Top
4 楼clhq_7404（lc）回复于 2006-03-19 22:17:44 得分 4
1，先打上sp3的补丁，Top
5 楼clhq_7404（lc）回复于 2006-03-19 22:19:24 得分 4
sql server2000的SP3 的补丁，就可以的，还有就是三个JAR的文件要在CLASSPATH中Top
6 楼javawolf（橡木之狼）回复于 2006-03-19 22:28:51 得分 4
出什么异常啊？把Exception的trace打出来看看Top
7 楼hskflyin（小海）回复于 2006-03-20 09:51:14 得分 0
登录方式和密码应该是没有问题的,我之前用jdbc-odbc桥就连接上了.
我原来没有打sp3补丁,刚打上了,再试,也还是不行
CLASSPATH是原来装jdk时设的,三个jar文件应该怎么加上?
在catch中加上了e.printStackTrace(),输出如下
D:\Develop\JbuilderX\jdk1.4\bin\javaw -classpath "C:\Documents and Settings\chenxu\jbproject\jdbcsqlserver\classes;E:\jdbcsqlserver\jdbcsqlserver\msbase.jar;E:\jdbcsqlserver\jdbcsqlserver\mssqlserver.jar;E:\jdbcsqlserver\jdbcsqlserver\msutil.jar;D:\Develop\JbuilderX\jdk1.4\demo\jfc\Java2D\Java2Demo.jar;D:\Develop\JbuilderX\jdk1.4\demo\plugin\jfc\Java2D\Java2Demo.jar;D:\Develop\JbuilderX\jdk1.4\jre\javaws\javaws.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\charsets.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\ext\dnsns.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\ext\ldapsec.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\ext\localedata.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\ext\sunjce_provider.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\im\indicim.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\im\thaiim.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\jce.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\jsse.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\plugin.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\rt.jar;D:\Develop\JbuilderX\jdk1.4\jre\lib\sunrsasign.jar;D:\Develop\JbuilderX\jdk1.4\lib\dt.jar;D:\Develop\JbuilderX\jdk1.4\lib\htmlconverter.jar;D:\Develop\JbuilderX\jdk1.4\lib\tools.jar" jdbcsqlserver
execute here
Driver successfully loaded.
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
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)connect failed.
[Ljava.lang.StackTraceElement;@10ef90c
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at jdbcsqlserver.getConnect(jdbcsqlserver.java:27)
at jdbcsqlserver.main(jdbcsqlserver.java:16)
Top
相关问题
- jdbc连接sqlserver的问题
- JDBC连接SQLServer数据库问题!!!
- (100分)jdbc连接sqlserver 200出错.[SQLServer 2000 Driver for JDBC]Error establishing socket.
- 连接websphere连接数据源提示"[IBM][SQLServer JDBC Driver is locked for use with embedded applications"
- JDBC连接局域网中SQLserver怎么写？
- 用JDBC连接SQLSERVER的问题！一定给分！
- jsp连接sqlserver使用jdbc驱动时，class not found
- 用JDBC连接SqlServer数据库的怪问题
- 求救用jdbc连接sqlserver数据库问题！
- 用JDBC直接连接SQLServer时提示错误：Error establishing socket
