我用SQLServer JDBC Driver出现如下错误,但用JDBC-ODBC能成功!急!急!急!
报错信息:
[Microsoft][SQLServer JDBC Driver][SQLServer]用户 'sa' 登录失败。原因: 未与信任SQL Server 连接相关联。
原程序:
import java.lang.*;
import java.io.*;
import java.sql.*;
import java.util.*;
//import infobase.mfunction;
class TestJDBC
{
public static void main(String[] args)
{
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Connection con=DriverManager.getConnection("jdbc:odbc:dbsource","sa","sa");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=InfoBase","sa","");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=InfoBase","sa","sa");
Statement stmt = con.createStatement();
String sqlString = "select ProcessName from PProcess";
ResultSet rs = stmt.executeQuery(sqlString);
while(rs.next()){
String ProcessName = rs.getString("ProcessName");
System.out.println(ProcessName);
}
}catch (java.lang.ClassNotFoundException e){
System.out.println(e.getMessage());
System.out.println("Not Found!");
}catch(SQLException e){
System.out.println(e.getMessage());
System.out.println("My Exception!");
}
}
}