Question

jsp连数据库报错

executeQuery:[Microsoft][ODBC 驱动程序管理器] 无效的字符串或缓冲区长度
public class DBconn
{
private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;
private String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
private String Connstr="jdbc:odbc:info";
private String username="";
private String password="";

public DBconn()
{
try
{
Class.forName(DBDriver);
}catch(ClassNotFoundException e)
{System.out.println("DBconn:classnotfoundexception");}

}
数据源名称是info 应该没错啊
我QQ 601248794

Answer 1

odbc的连接字符串写对没？仔细检查下

追问

能加下我QQ详细说么 ？

Answer 2

连接connection的url错误，你检查检查，看哪写错了，或者你把代码贴出来

追问

能加下我QQ详细说么 ？

追答

public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "SYSTEM", "sdada");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}

追问

我用的是SQL2000啊 。

追答

public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection(
"jdbc:sqlserver://localhost:1433;databaseName=dbone", "sa", "sa");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}

追问

要通过ODBC来连接啊 。

Answer 3

你把URL一起发出来 肯定是后面有参数

追问

能加下我QQ详细说么 ？

Answer 4

飘过····做任务···