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