problem connecting to access

[panindra nath]

HI,this my servlet code for retreiving contents from the database using ms-access......whenever i launch browser and type in the URL it throws an error


java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

so what should be the remedy to this problem?

thanks...




import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class test extends HttpServlet
{
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException
{

response.setContentType("text/html");
PrintWriter pw = response.getWriter();
Connection connection=null;


try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection("jdbc:odbc:db2");
Statement st = connection.createStatement();
ResultSet rs = st.executeQuery("select * from emp");
while(rs.next())
{
pw.println(rs.getString(1));
pw.println(rs.getString(2));
pw.println(rs.getString(3));
pw.println();
}
}
catch (Exception e)
{
pw.println(e);
}
}
}

[Herman Schelti]

hi,

did you define a datasource (see settings - control panel - administrative tools).

Don't understabd why you want to call it db2.

Herman

[panindra nath]

YES i did,i selected ms access driver(*.mdb)
User data source as db2
database c:\db2.mdb;

The statement /*connection = DriverManager.getConnection("jdbc:odbc:db2");*/ is throwing the exception.... so i think there s something wrong with the path "jdbc:odbc:db2".Can you please send me correct path ? Do i need to install any driver for connecting servlet to ms-access?

[Rob Spoor]

Did you create the DSN as a user DSN or a system DSN?

[Hareendranath Babu Kotha]

Hi ,

I also got the same problem, but it got resolved once i selected System DSN instead of User DSN. So, trying with System DSN will resolve your problem.

[kkk guptha]

For MS-Access connection,
-- First you have to register DSN and make username and password there.
-- After that link the database of your application to that DSN.
-- In the connection statement, mention as
connection myconn = DriverManager.getConnection("jdbc:odbc:DSNname","username","password");



---KKK Guptha