恳请前辈邦看一下java程序链接MSSQL2000失败的原因,
请高手们帮我找原因,用微软自己的VC++6.0链接SQL2000失败,换用JAVA链接可以加载
驱动,却链接不上数据库,链接的关键代码和运行时返回的错误贴在下面,恳请前辈们
帮帮我,看一下!谢谢!
数据源是系统数据源安装SQL Server 2000 Driver for JDBC Service Pack 3.exe之后打了两个SP4的补丁:
SQL2000-KB884525-SP4-x86-CHS.EXE
SQL2000.AS-KB884525-SP4-x86-CHS.EXE
****************************************************************************Microsoft SQL Server 2000 Driver for JDBC链接代码如下:************
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("Success loading MSsql Driver!\n");
}
catch (Exception e) {
System.out.print("Error loading MSsql Driver!");
e.printStackTrace();
} try {
Connection connect = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs", "sa", "my");
System.out.println("Success connect Mysql server!");
}
catch (Exception e) {
System.out.print("get data error!\n\n");
e.printStackTrace();
}*********************编译通过,运行错误提示如下:********************
Success loading Driver!get data error!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 Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at testmssql.main(testmssql.java:15)
***************************************************************
请高手们帮我找原因,用微软自己的VC++6.0链接SQL2000失败,换用JAVA链接可以加载
驱动,却链接不上数据库,链接的关键代码和运行时返回的错误贴在下面,恳请前辈们
帮帮我,看一下!谢谢!
数据源是系统数据源安装SQL Server 2000 Driver for JDBC Service Pack 3.exe之后打了两个SP4的补丁:
SQL2000-KB884525-SP4-x86-CHS.EXE
SQL2000.AS-KB884525-SP4-x86-CHS.EXE
****************************************************************************Microsoft SQL Server 2000 Driver for JDBC链接代码如下:************
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("Success loading MSsql Driver!\n");
}
catch (Exception e) {
System.out.print("Error loading MSsql Driver!");
e.printStackTrace();
} try {
Connection connect = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs", "sa", "my");
System.out.println("Success connect Mysql server!");
}
catch (Exception e) {
System.out.print("get data error!\n\n");
e.printStackTrace();
}*********************编译通过,运行错误提示如下:********************
Success loading Driver!get data error!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 Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at testmssql.main(testmssql.java:15)
***************************************************************
解决方案 »
- 使用Sqlserver2005开发,如何让用户不安装Sqlserver2005也可以使用??
- 求一段sql语句的优化
- SQL SEVER中无法存储8.00这样的数据,请问怎么处理!
- SQL SERVER用户权限问题,如何将所有表的Select权限赋给新用户?
- SQL COUNT 语句为NULL的问题
- vb+sqlserver开发问题,,很菜的,请指教!
- 从一个表中找出符合条件的记录,并更新另一个表的SQL语句如何写
- 要对成绩表按照 班号 来查询某人的学期排名 在线求教
- 哪里有sybase的书?我有个问题:select into 语句要怎样打开?详细一些好吗?
- 有一个表叫A,我想把它改名为B,应该怎样写SQL语句呀?
- 请高手解释一下odbc、oledb、ado、ado.net的概念,之间的联系与区别?
- 升级SQL
Connection connect = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs", "sa", "my");修改为:
Connection connect = DriverManager.getConnection(
"jdbc:microsoft:sqlserver;userid=adu;password=my://localhost:1433;DatabaseName=pubs", "sa", "my");连接时提示如下:
*******************************************************************
G:\java>java mssql
Success loading MSsql Driver!get data error!java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at mssql.main(mssql.java:15)
**********************************************************************
还是不成功,请帮忙!