problem in - JDBC Connection for MS-Access in JSP
Hi,
I am using Three tier Architecture. that is MS-Access as a Database, JAva Web Server as a server and HTML as a frontend.
I always getting error during the execution of JSP code.
Coding in JSP:
<%@ page import="java.sql.*"%>
<%
java.sql.Connection con;
java.sql.PreparedStatement pstmt;
java.sql.ResultSet rst;
String sDBQ= application.getRealPath("dem.mdb");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ="+sDBQ);
pstmt = con.prepareStatement("select * from employee");
rst = pstmt.executeQuery();
if (rst.next())
{
String s1=rst.getString("EmployeeId");
String s2=rst.getString("EmployeeName");
out.println(s1);
out.println(s2);
}
}
catch(Exception e)
{
out.println("Error "+e);
}
%>
I'm getting this error
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name too long
Please anyone rectify it
