Solved

Connect and retrieve data from MS access from java

Posted on 2011-03-15
9
412 Views
Last Modified: 2012-06-27
String myDB =	"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/CRDUtil/data/CRD1.MDB";
con = DriverManager.getConnection(myDB,"","");
rs = stmt.executeQuery(sqlStr); //throws nullpointerexception

Open in new window


the last line throws exception.
0
Comment
Question by:PearlJamFanatic
  • 5
  • 3
9 Comments
 

Author Comment

by:PearlJamFanatic
ID: 35136372
do ineed to install something to get this working. I was connecting to oracle (using a different comnnection string) till now and it was working.
0
 
LVL 47

Expert Comment

by:for_yan
ID: 35136387
You need to specify data source in ODBC
0
 
LVL 92

Expert Comment

by:objects
ID: 35136396
you not creating a Statement
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 47

Expert Comment

by:for_yan
ID: 35136412

That's how I did connection to MS:

If you don't have user password just two empty lines should do like nothing between the quotes: "",""
-------------------------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con1 = DriverManager.getConnection("jdbc:odbc:DataSourceName","user","passowrd");

Statement stmt1 = con1.createStatement();

ResultSet rs1 = stmt1.executeQuery("select Methods.MethodId, Methods.RunTime from Methods");
---------------------------------
0
 

Author Comment

by:PearlJamFanatic
ID: 35136413
for_yan: how do i do that?
0
 

Author Comment

by:PearlJamFanatic
ID: 35136428
0
 
LVL 47

Accepted Solution

by:
for_yan earned 500 total points
ID: 35136431
you go to control panel - administartive tools - ODBC - System DSN tab - add - Micosoft Access Driver(*mdb)  - specify dataosurce name and description (latter not important)  - then select and browse to the .mdb file
0
 
LVL 47

Assisted Solution

by:for_yan
for_yan earned 500 total points
ID: 35136438
The datasource name should be the same as in Connection con1 = DriverManager.getConnection("jdbc:odbc:DataSourceName","user","passowrd");
0
 
LVL 47

Expert Comment

by:for_yan
ID: 35136446
Perhaps rgagnon eamples should also work, but I didn't try it taht way - I used ODBC, and it worked for me
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
object oriented programming comparison 5 77
type mismatch (Object[] to double[] 4 33
iterator/ListIterator approach 17 39
eclipse buid path vs tomcat lib path 10 34
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question