This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 60785
    
  65

Moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
wood burning stoves
 
subject: DSN less MS access Connection using JSP - help needed
 
Similar Threads
no dafault driver specified
Connecting to MS Access 2000
connecting to ms access database
Error trying to connect MS Acess 12 database
Netbeans and MS Access