首先SQL Server有三个jar文件都必须放在CLASSPATH中,其次连接方式
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://tiger:1433;DatabaseName=forum;User=sa,Password=");
改为
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://tiger:1433","sa","");就行了
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://tiger:1433;DatabaseName=forum;User=sa,Password=");
改为
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://tiger:1433","sa","");就行了
Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);
Connection conn = DriverManager.getConnection(jdbc:microsoft:sqlserver://123.456.789.1:1433;DatabaseName=MyDB,sa,"");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ytoa","sa",""); 或Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.98.1.78:1433;DatabaseName=ytoa","sa",""); 或Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.98.1.78:1433/ytoa","sa",""); 都不行呀!!请赐教,100分!