aspose file tools*
The moose likes JDBC and the fly likes DSN less MS access Connection using JSP - help needed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DSN less MS access Connection using JSP - help needed" Watch "DSN less MS access Connection using JSP - help needed" New topic
Author

DSN less MS access Connection using JSP - help needed

Senthilkumar Changepond
Greenhorn

Joined: May 24, 2005
Posts: 4
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

Joined: Aug 02, 2004
Posts: 19
Get a JDBC driver for MS Access instead of JDBC-ODBC bridge.
JDBC Driver
Senthilkumar Changepond
Greenhorn

Joined: May 24, 2005
Posts: 4
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

Joined: Jan 10, 2002
Posts: 61768
    
  67

Moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DSN less MS access Connection using JSP - help needed