DSN less MS access Connection using JSP - help needed

[Senthilkumar Changepond]

DEar All ,

I got the problem while I connect the MS access database without using DSN .

here the Code :
==============

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

String database ="jdbc dbc river={Microsoft Access Driver(*.mdb)};DBQ=c:/db2.mdb;DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection( database ,"","");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from login" );
%>

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

My requirement is , I want to Connect MS Access database with out using DSN .
I know how to Connect MS access DB using DSN . without DSN I have problem .

PLZ PLZZZZZZZZZZZZ ,

help me .. I am waiting for the result .

plz reply ASAP

regards ,
B.SENTHILKUMAR

[leon fan]

Get a JDBC driver for MS Access instead of JDBC-ODBC bridge.
JDBC Driver

[Senthilkumar Changepond]

Thank you .
Leon fan .

I haven't the JDBC/odbc jar files . I found out the jar files can be placed under tomcat4.1(or)5.0\common\lib\ .

if you don't mind plz give the url for Downloading the Free JDBC driver for MS Access .

Thanks in Advance .

REgards ,
B.SENTHILKUMAR

[Bear Bibeault]

Moved to the JDBC forum.