Java开发网 - 求救：jdbc连接MSSQL的问题

Topic: 求救：jdbc连接MSSQL的问题

1.求救：jdbc连接MSSQL的问题

Posted by: sisili
Posted on: 2004-08-31 19:15

我用jdbc-odbc可以连接上，用jdbc就不行。
具体如下

jdbc-odbc程序：

import java.sql.*;

public class JdbcOdboSQLServerDemo {
public static void main(String[] args) throws Exception {
String url = "jdbc:odbc:NorthwindSQLServer";
//创建连接类
Connection conn;
try{
//告诉程序使用jdbc与odbc桥创建数据库联接
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("JDBC-ODBC的驱动程序注册成功");
}catch(Exception e){
e.printStackTrace();
System.out.println("找不到JDBC-ODBC的驱动程序");
}
try{
//使用DriverManager类的getConnection()方法建立联接,
//第一个字符参数定义用户名，第二个字符参数定义密码
conn = DriverManager.getConnection(url, "sa", "");
System.out.println("数据库联接成功");
}catch(Exception e){
e.printStackTrace();
System.out.println("URL定义错误，找不到相关的数据源");
}
}

}

这个程序可以运行

jdbc程序：

import java.sql.*;

public class Type4DriverDemo {
public static void main(String[] args) {
try{
//告诉程序使用jdbc桥创建数据库联接
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("数据库驱动程序注册成功");
//使用DriverManager类的getConnection()方法建立联接
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind;User=sa;Password=");

System.out.println("成功联接数据库");
}catch(Exception e){
e.printStackTrace();
System.out.println("数据库联接失败");
}
}
}

运行后，显示的信息是：

数据库驱动程序注册成功

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。

  at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

  at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

  at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

  at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

  at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

  at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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:193)

  at Type4DriverDemo.main(Type4DriverDemo.java:10)

数据库联接失败

请问哪里错啦？郁闷ing

2.Re:求救：jdbc连接MSSQL的问题 [Re: sisili]	Copy to clipboard
Posted by: why Posted on: 2004-08-31 20:37 0. don't use blank password. 1. have you tried again with a sa password? 2. how about adding a ; after Password= ? i.e. Password=;" 3. have you tried the getConnection(url, user, pwd); format? 4. is your SQL Server's security mode "Windows only"?