连接sql server问题（急）
小妹帮别人问的。据他本人所说，用记事本编好了代码，然后再IE上调试。
在用ODBC连接成功，而用JDBC连接不成功。安装了sql驱动
jsp（selectUserTable2.jsp）代码如下：
<%@ page contentType= "text/html;charset=GB2312 " %>
<%@ page import= "java.sql.* " %>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
}
catch(ClassNotFoundException e)
{
out.print( "类找不到！ ");
}
try
{
con=DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabase ", "sa ", "6599996 ");
sql=con.createStatement();
rs=sql.executeQuery( "SELECT * FROM userTable ");
out.print( " <Table Border> ");
out.print( " <TR> <td colspan=8 align=center> 用户数据 </td> </tr> ");
out.print( " <TR> ");
out.print( " <Td width=100 > "+ "用户ID号 ");
out.print( " <Td width=50 > "+ "用户名 ");
out.print( " <Td width=100> "+ "用户真实姓名 ");
out.print( " <Td width=50> "+ "年龄 ");
out.print( " <Td width=50> "+ "性别 ");
out.print( " <Td width=100> "+ "联系地址 ");
out.print( " <Td width=100> "+ "联系电话 ");
out.print( " <Td width=100> "+ "添加时间 ");
out.print( " </TR> ");
while(rs.next())
{ out.print( " <TR> ");
out.print( " <TD > "+rs.getLong(1)+ " </TD> ");
out.print( " <TD > "+rs.getString(2)+ " </TD> ");
out.print( " <TD > "+rs.getString(4)+ " </TD> ");
out.print( " <TD > "+rs.getInt( "user_age ")+ " </TD> ");
out.print( " <TD > "+rs.getString( "user_sex ")+ " </TD> ");
out.print( " <TD > "+rs.getString( "user_address ")+ " </TD> ");
out.print( " <TD > "+rs.getString( "user_telephone ")+ " </TD> ");
out.print( " <TD > "+rs.getString( "add_time ")+ " </TD> ");
out.print( " </TR> ") ;
}
out.print( " </Table> ");
con.close();
}
catch(SQLException e1)
{
out.print( "SQL异常！ ");
}
%>
</BODY>
</HTML>
在ie上输入：http://localhost:8080/selectUserTable2.jsp
出错问题如下：
HTTP Status 500 -
--------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Exception in JSP: lectUserTable2.jsp:18
其实是在
con=DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabase ", "sa ", "6599996 ");
这里出错，用户名和密码都正确。
请问各位大侠是什么问题？
[解决办法]
3个.
[解决办法]
protected Connection conn = null;
String dburl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xxxx ";
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
conn = DriverManager.getConnection(dburl, "sa ", " ");
先看有没有数据库的jar包，有的话，你和我给你的对一下，看看
[解决办法]
没tomcat直接跑程序。。
[解决办法]
牛人呀,这里看来牛人太多了
[解决办法]
使用JTDS驱动包。网上去下载，加载到你的工程路径就可以了。。
网上这样的例子太多了。。。
[解决办法]
好像运行jsp程序需要一个服务器的吧，比如tomcate or jboss什么的，好像asp程序没有iis能运行？？我没听说，mark,
[解决办法]
看看这个文章吧
http://www.knowsky.com/5438.html
Mssql server 2000的官方jdbc driver ，可以到微软的官方网站免费下载
http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en
[解决办法]
我怎么记得sqlserver连接串中主机和端口之间是用逗号分隔的？
[解决办法]
把包放到web-inf/lib下
[解决办法]
UP LS
我的异常网推荐解决方案：The server encountered an internal error () that prevented it from fulfilling this request.,http://www.myexception.cn/java-web/317.html