老问题:JDBC-ODBC的连接
已经配置好了数据源,使用另外一个主机上的数据库,使用的是SQLSERVER7,源程序如下
import java.io.*;
import java.sql.*;
public class odbctry
{
public static void main(String args[]) throws InstantiationException,IllegalAccessException{
Connection dbCon;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
System.out.println("ok");
dbCon=DriverManager.getConnection("jdbc:odbc:personal");
System.out.println("ok");
ResultSet rs;
Statement stmt;
StringBuffer qry=new StringBuffer(1024);
System.out.println("connect");
qry.append("select * from pi_infomation");
stmt=dbCon.createStatement();
rs=stmt.executeQuery(qry.toString());
int i=0;
while (rs.next()) {
System.out.println(rs.getString(i++));
}
} catch (ClassNotFoundException e) {
System.out.println("driver not found");
return;
} catch(SQLException e) {
System.out.println("error connect");
return;
}
}
}
结果输出:
ok
error connect
问题出在哪儿呢?