Driver driver=(Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.registerDriver(driver);
换成Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
否则与你的URL不匹配
DriverManager.registerDriver(driver);
换成Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
否则与你的URL不匹配
// String url = "jdbc:mysql://202.96.0.1/real";
String url = "jdbc:odbc:mysql";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection(url, "root", "");
...注释中队应的是不用DSN的情况
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:test_number","username","password");或者:
Driver driver=(Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.registerDriver(driver); Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://servername:1433;databaseName=test","miniflashow","miniflashow");