jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Access DB Connect Issues Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Access DB Connect Issues" Watch "Access DB Connect Issues" New topic
Author

Access DB Connect Issues

Bill Warner
Greenhorn

Joined: Aug 30, 2006
Posts: 3
The following code:

public Connection getConnection(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String filename = "c:/IssuanceTracker/IssuanceTracker.mdb";
String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";database+= filename.trim();
System.out.println(database);
Connection con = DriverManager.getConnection( database ,"","");
return con;
}
catch (Exception e) {
System.out.println("Error: " + e);
e.printStackTrace();
return null;
}
}

Yields the following error:

java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:538)
at java.sql.DriverManager.getConnection(DriverManager.java:188)
at issuancetracker.DataAccess.getConnection(DataAccess.java:27)
at issuancetracker.testmain.main(testmain.java:21)

I've included the rt.jar file in my project. I'm using WSAD 5.1.2. Can anyone please help. Thanks, Bill
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";database+= filename.trim();


try this

String url ="jdbcdbcRIVER={Microsoft Access Driver
(*.mdb)};DBQ= c:\\IssuanceTracker\\IssuanceTracker.mdb";

[ August 31, 2006: Message edited by: Saif Uddin ]

Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
Bill Warner
Greenhorn

Joined: Aug 30, 2006
Posts: 3
Thanks for the replies! I get the same errors with the suggested changes.

I could really use some help. I'm new to Java and this problem doesn't seem to make sense. Co-workers can execute the same code successfully w/o error. Any help would be appreciated.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
Instead of accessing the MDB file directly, have you tried setting up an ODBC data source? Some info about that can be found here.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Access DB Connect Issues
 
Similar Threads
SQL Server 2000 JDBC Driver Error
Why cant connect to another computer in lan?
Syntax of getConnection() method
SQLException on connect
connect to SQLServer Database in XP?