|
Hi All,
i'm new to JSP
Can you please help me how to connect MS Access Database in JSP
Thanks
sunny
|
|
|
hi sir ,
i hope u remember me .the eagent project student
as i have worked a lot on jsp the following is correct for my knowledge.
<%@ page language="java" %>
<%@ page import ="java.sql.*" %>
.....
<%
Connection con=null;
PreparedStatement ps=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:db1");
....(using ps set strings)
ps.executeUpdate();
%>
|
|
|
Try this
<%@ page language="java" %>
<%@ page import ="java.sql.*" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ= Authors.mdb";
;DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection( database ,"","");
%>
<Added>
Try this
<%@ page language="java" %>
<%@ page import ="java.sql.*" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ= C:\Authors.mdb";
;DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection( database ,"","");
%>
|
|
|
hi kanad sir,
i used this tips but there is a error which is follows
Generated servlet error:
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\university.mdb;DriverID=22;READONLY=true;";
please help to remove this error
|
|
|
|
|
|
|
|