jdbc?

[liumin3285]

返回：url出现问题
/*
  Sql2000
  sp4包也打上了
 jdbc驱动也装上了
msbase.jar 、mssqlserver.jar、msutil.jar都放在lib下了
装数据库装的时候是用windows身份验证的 用户和密码我都有空
环境变量也设置了
classpath
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
*/
          public static Connection getConnection() throws InstantiationException, IllegalAccessException{
		Connection con = null;
		String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=my_date"; 
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
		}catch(ClassNotFoundException e){
			System.out.println("Class类没找到");
		}
		try{
			con = DriverManager.getConnection(url,"","");
		}catch(Exception e)
		{
			System.out.println("url出现问题");
		}
		return con;
	}

[liumin3285]

//java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
//我sql装的时候是用windos身份验证的
 // user 应该是

[zhangwenmin]

jdbc:microsoft:sqlserver://server_name:1433没错
;DatabaseName=my_date这个就检查下吧

[liumin3285]

my_date是我的数据库
我建做测试的