Help! DriverManager.getConnection problem

When I to connect to a access databse with a jdbc-odbc bridge it connects fine and everything works out.But when I try to connect the same database from the servlet in my tomacat4.0 DriverManager.getConnection("jdbc

dbc

D","",""); is not working.Can anyone please help me.bye.
[ December 19, 2002: Message edited by: Thomas Paul ]

What is not working? What error message(s) are you getting?

java.sql.SQLException

add the username and password in the last 2 block of apostrophes
coz ur exception is too general and usually this means somehting went wrong in ur sql statement or u might be using a null connection to try and set up a statement.....so many causes that can relate to this SQLException

oh i think in tomcat , when u r getting a connection using DriverManager, u suppose to supplie an URL.....something like
"jdbc:informix-sqli://%dbhost%:%portNum/dbname:INFORMIXSERVER=%dbserver%;user=XXXXX;password=XXXXX;"
try this ....but u have to find out what u have to type in the url coz this is for Informix db

"Cobras9",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Please change your display name soon, accounts with invalid display names get deleted
Thanks.
Dave

Copied from the duplicate thread
Originally posted by raj guntupalli :

import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class TestServlet extends HttpServlet
{
    Connection dbConnection;
    /* public void init() 
    {
        // ServletConfig config=getServletConfig();
        // System.out.println(getServletName()+":Initializing...");
        // String driverClassName=config.getInitParameter("driverclassname");
        // String dbURL=config.getInitParameter("dburl");
        // String username=config.getInitParameter("username");
        // String password=config.getInitParameter("password");
    /* try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(ClassNotFoundException e){System.out.print("beep");}
        /* try
        {
            dbConnection=DriverManager.getConnection("jdbc  dbc  b1","hello","welcome");
        }catch(SQLException e){}
            System.out.println("Initialized");*/
        // }
    public void service(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
    {
        PrintWriter pw=res.getWriter();
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            dbConnection=DriverManager.getConnection("jdbc  dbc  D","","");
            Statement smt=dbConnection.createStatement();
            ResultSet r=smt.executeQuery("SELECT * FROM MySQLODBC");
            pw.println("<html>");
            pw.println("<body>");
            pw.println("<h1>hello</h1>");
            while(r.next())
            {
                int j=r.getInt("ID");
                String s = r.getString("name");
                int i = r.getInt("age"); 
                pw.println("ROW = "+j+" " + s + " " + i); 
            }
            pw.println("</body>");
            pw.println("</html>");
            smt.close();
            dbConnection.close();
        }
        catch(Exception e)
        {
            pw.println("<html>");
            pw.println("<h1>"+e+"no result</h1>");
            pw.println("</html>");
        }
    }
}