Tags: access, code, connect, connection, database, dear, dsn, java, jsp, pages, server

DSN less MS access Connection using JSP - help needed

On Java Studio » Java Server Pages (JSP)

1,554 words with 3 Comments; publish: Tue, 15 Jul 2008 08:37:00 GMT; (15062.50, « »)

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

All Comments

Leave a comment...

  • 3 Comments
    • Get a JDBC driver for MS Access instead of JDBC-ODBC bridge.

      JDBC Driver

      #1; Tue, 15 Jul 2008 08:38:00 GMT
    • 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

      #2; Tue, 15 Jul 2008 08:40:00 GMT
    • Moved to the JDBC forum.
      #3; Tue, 15 Jul 2008 08:41:00 GMT