aspose file tools*
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: 42608
    
  65
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 - my free Android networking tools app
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Access DB Connect Issues