odbc数据源已创建,名为try1`(它连接的数据库是try1),用户名是:osrui,密码为:0000jsp源程序是:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import = "java.sql.*" %>
<html>
<body>
<center>
<h3>SQL Server连接jdbc例反方格 srui </h3>
<%
String error1="";
try{
//String sqlServerDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Connection conn;
// Class.forName( sqlServerDriver );
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
out.println( "注册成功<br>" );
//conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sqlserverdemo","","");
conn = DriverManager.getConnection( "jdbc.odbc.try1","osrui","8262862");
out.println("<p>成功连接sqlserverdemo数据库的连接。</p>"); }catch(Exception e){
out.print(e.toString());
}%>
</center>
</body>
</html>
出现的问题提示:
SQL Server连接jdbc例反方格 srui
注册成功
java.sql.SQLException: No suitable driver
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import = "java.sql.*" %>
<html>
<body>
<center>
<h3>SQL Server连接jdbc例反方格 srui </h3>
<%
String error1="";
try{
//String sqlServerDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Connection conn;
// Class.forName( sqlServerDriver );
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
out.println( "注册成功<br>" );
//conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sqlserverdemo","","");
conn = DriverManager.getConnection( "jdbc.odbc.try1","osrui","8262862");
out.println("<p>成功连接sqlserverdemo数据库的连接。</p>"); }catch(Exception e){
out.print(e.toString());
}%>
</center>
</body>
</html>
出现的问题提示:
SQL Server连接jdbc例反方格 srui
注册成功
java.sql.SQLException: No suitable driver
这个地方好像错了吧!