Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DSN less MS access Connection using JSP - help needed

 
Senthilkumar Changepond
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Get a JDBC driver for MS Access instead of JDBC-ODBC bridge.
JDBC Driver
 
Senthilkumar Changepond
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author and ninkuma
Marshal
Pie
Posts: 64626
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to the JDBC forum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic