用jdbc-odbc bridge连接sql server 数据库为何总出错?
我想编写一个java程序和sql server 数据库连接,代码如下:
import java.sql.*;
public class Jdbc_test {
public static void main(String args[]) {
String url = "jdbc:odbc:Northwind";
Connection con;
String createString;
createString = "create table COFFEES " +
"(COF_NAME VARCHAR(32), " +
"SUP_ID INTEGER, " +
"PRICE FLOAT, " +
"SALES INTEGER, " +
"TOTAL INTEGER)";
Statement stmt;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con = DriverManager.getConnection(url, "sa", "jxj73211");
stmt = con.createStatement();
stmt.executeUpdate(createString);
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
编译通过后运行,产生下列错误信息:
SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
请教各位高手,原因是什么?多谢!