我在项目里加入了jdbc驱动,也配置了
CLASSPATH
E:\eclipse\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\chs\sqljdbc.jarjsp代码是
<%
//Class.forName("com.microsoft.jdbc.driver.SqlServerDriver").newInstance();
//String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=201103";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://117.21.250.90:1433; DatabaseName=elive";
String user = "qjy";
String pwd = "qjy123";
Connection conn = DriverManager.getConnection(url, user, pwd);
Statement stmt = conn
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select c1,c2 from area";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
%>----------------------------------------------------------------------------
报错的代码是
严重: Servlet.service() for servlet jsp threw exception
com.microsoft.sqlserver.jdbc.SQLServerException: 无法打开登录所请求的数据库 "elive"。登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)请问到底是哪里出错了
CLASSPATH
E:\eclipse\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\chs\sqljdbc.jarjsp代码是
<%
//Class.forName("com.microsoft.jdbc.driver.SqlServerDriver").newInstance();
//String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=201103";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://117.21.250.90:1433; DatabaseName=elive";
String user = "qjy";
String pwd = "qjy123";
Connection conn = DriverManager.getConnection(url, user, pwd);
Statement stmt = conn
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select c1,c2 from area";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
%>----------------------------------------------------------------------------
报错的代码是
严重: Servlet.service() for servlet jsp threw exception
com.microsoft.sqlserver.jdbc.SQLServerException: 无法打开登录所请求的数据库 "elive"。登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)请问到底是哪里出错了
其次确认密码和用户名和数据库是不是匹配的,若不是就Config下。
String url="jdbc:sqlserver://117.21.250.90:1433; DatabaseName=elive"; 那么从楼主的开发机登录117.21.250.90上的数据库elive肯定登录不上,你可以用sqlserver的连接工具试一下,就是SQL SERVER2005默认的登录工具。