Hi,
You probably just need to make sure the classpath
that the http server is using is the same as the
one that you have during the command line session.
The odbc drivers are possibly missing from the
http server servlet environment. What http
server are you using?
-Scott
----- Original Message -----
From: "Mehmet Gurmen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 16, 2001 4:36 PM
Subject: Re: ms access driver in a servlet
> Attached is the code:
> Please note that this code works within a command line if I add
> main(string[]) function.
> There is no problem with setting up the dsn or odbc. I havent figured out
> why it does not work within a servlet?
> --------------------------------------------------------
> import java.io.*;
> import java.sql.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
>
> public class tappDisplay extends HttpServlet {
>
> public void init()
> {
> try{
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
> }catch(Exception e){e.printStackTrace();}
> }
>
> public void doGet(HttpServletRequest req, HttpServletResponse res)
> throws ServletException, IOException {
>
>
> Connection con = null;
> Statement stmt = null;
> String sUserType = null;
> String sUserIsAuthorized = null;
> ResultSet rs = null;
> HttpSession ses = req.getSession(true);
>
> res.setContentType("text/html");
> PrintWriter out = res.getWriter();
>
> try {
>
> out.println("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0
> Transitional//EN'
> 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
> out.println("<html>");
> out.println(" <head>");
> out.println("<title></title>");
> out.println("<meta http-equiv='Content-Type' content='text/html;
> charset=windows-1252' />");
> out.println("<meta name='Keywords' content='' />");
> out.println("<meta name='Description' content='' />");
> out.println("<meta http-equiv='pragma' content='no-cache' />");
> out.println("<meta http-equiv='cache-control' content='no-cache'
> />");
> out.println("<link rel='stylesheet' type='text/css' href='/std.css'
> />");
> out.println("</head>");
> out.println("<body>");
>
>
> //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> //con =
DriverManager.getConnection("jdbc:odbc:dsn_customers","","");
> java.util.Enumeration en = DriverManager.getDrivers();
> while(en.hasMoreElements())
> {
> Driver s = (Driver) en.nextElement();
> out.println("["+s.toString()+"]");
> }
>
> con = DriverManager.getConnection("jdbc:odbc:ex");
>
>
> stmt = con.createStatement();
> rs = stmt.executeQuery("SELECT * FROM [T_IND]");
> out.println("<table><tr>");
> out.println("<th>NAME</th>");
> out.println("<th>STREET</th>");
> out.println("<th>CITY</th>");
> out.println("<th>STATE</th>");
> out.println("<th>ZIP</th>");
> out.println("<th>MYDATE</th>");
> out.println("<th>SOURCE</th>");
> out.println("<th>ETHNIC</th>");
> out.println("<th>EMAIL</th>");
> out.println("<th>PRIMID</th>");
> out.println(" </tr><tr> ");
> while (rs.next())
> {
>
> String sNAME = rs.getString("NAME");
> String sSTREET = rs.getString("STREET");
> String sCITY = rs.getString("CITY");
> String sSTATE = rs.getString("STATE");
> String sZIP = rs.getString("ZIP");
> String sMYDATE = rs.getString("MYDATE");
> String sSOURCE = rs.getString("SOURCE");
> String sETHNIC = rs.getString("ETHNIC");
> String sEMAIL = rs.getString("EMAIL");
> String sPRIMID = rs.getString("PRIMID");
>
> out.println(" <tr> ");
> out.println("<td align=left>" + sNAME + "</td>");
> out.println("<td align=left>" + sSTREET + "</td>");
> out.println("<td align=left>" + sCITY + "</td>");
> out.println("<td align=left>" + sSTATE + "</td>");
> out.println("<td align=left>" + sZIP + "</td>");
> out.println("<td align=left>" + sMYDATE + "</td>");
> out.println("<td align=left>" + sSOURCE + "</td>");
> out.println("<td align=left>" + sETHNIC + "</td>");
> out.println("<td align=left>" + sEMAIL + "</td>");
> out.println("<td align=left>" + sPRIMID + "</td>");
> out.println("</tr>");
>
> }
>
> out.println("</table>");
> out.println("</body></html>");
> }
>
>
> catch(SQLException e)
> {
> e.printStackTrace(out);
> //out.println("SQL Error: "+ e.getMessage());
> }
> finally
> {
> try
> {
> if (con != null) con.close();
> }
> catch (SQLException ignored) { }
>
> }
> }
>
> }
>
> --------------------------------------------------------
>
>
> check
> whether driver is there in the class path used by webserver or not.
> check whether u have registered the driver with Database Manger or
> not in the init or static method.
>
>
> Regards
> sathya
>
> -----Original Message-----
> From: Mehmet Gurmen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 16, 2001 12:04 AM
> To: [EMAIL PROTECTED]
> Subject: ms access driver in a servlet
>
>
> Hi all,
>
> I have installed j2ee including Sun's web server on a win2K
> professional.
> I wrote a simple servlet that gets a resultset from an ms access 2000
> database which I use the odbc-jdbc driver to connect to.
> I included a main function into the servlet and the class seems to get
> the
> resultset when I run it within a command prompt. But when I call that as
> a
> servlet, it just puts into the error log "No Suitable Driver Found".
> I do not think that there are any other drivers than that comes with the
> j2ee form ms access. I have been developing server side applications
> that
> could easily connect to system dsn's but when it comes to the servlet I
> get
> this message. Does the servlet only accept SQL server in the dsn? Can't
> I
> use ms access database?
>
> Thanks
>
> ________________________________________________________________________
> ___
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
