MS access connection string required urgently please....

hi

http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html

or

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String sTable = "AbTabelle2";

String sSql = "SELECT * FROM " + sTable + " order by [" + sOrder + "]";

String sDBQ = "C://test/test.mdb";

String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + sDBQ + ";DriverID=22;READONLY=true";

Connection cn = null;

Statement st = null;

ResultSet rs = null;

try {

cn = DriverManager.getConnection( database ,"","");

st = cn.createStatement();

rs = st.executeQuery( sSql );

-

}

catch(SQLException e){}

--

drvijayy2k2a at 2007-7-12 17:44:10 >

hey am getting this error.. wat i have to do please any one help me..

javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)

org.apache.jsp.HR_jsp._jspService(HR_jsp.java:116)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

ravi-kumar-123a at 2007-7-12 17:44:10 >