Question

JAVA的odbc问题 sun.jdbc.odbc后面我点不出来JdbcOdbcDriver 然后强行写上去竟然报错。。 怎么办

package test1;
import java.sql.*;
public class t1 {

public static void main(String[] args) {
// TODO Auto-generated method stub
Connection ct = null;
Statement sm = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:mytest, sa, sa");
sm = ct.createStatement();
int i = sm.executeUpdate("insert into xx values('11','cmh11','10','6')");
if(i == 1){
System.out.println("成功");
}else{
System.out.println("失败");
}
}catch(Exception e){
e.printStackTrace();
}finally{
if(sm != null){
try {
sm.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

if(ct != null){
try {
ct.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

}

}
报错信息是java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at test1.t1.main(t1.java:11)

Answer 1

没导包
要不然就是
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:mytest, sa, sa");
其中一个的字符串写错了

Answer 2

没驱动类

追问

详细一点的？

追答

Hi