File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Problem with connection to remote access database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with connection to remote access database" Watch "Problem with connection to remote access database" New topic
Author

Problem with connection to remote access database

Abey Thampy
Greenhorn

Joined: Nov 30, 2011
Posts: 2
Hi,
I am facing an issue while connecting to ms access db in shared drive without using DSN.While debugging java compiler crashed after executing Connection statement(DriverManager.getConnection()).I am using java1.6.Can anyone help in solving this issue?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18991
    
    8

Quite likely. Why don't you tell us about your problem? (Read our FAQ entry TellTheDetails for more about that.)
Abey Thampy
Greenhorn

Joined: Nov 30, 2011
Posts: 2
Hi
I am using normal jdbc for getting the connection.Please find the below code.
File file = new File("G:/TestData/DP.accdb");
Connection cn=DriverManager.getConnection("jdbcdbcriver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+file.getAbsolutePath()+";DriverID=22;READONLY=true","","");

But after executing this line JVM crashed and shows the crashed message popup window(terminated, exit value: -1073741811).

The location specified(G drive) is a shared drive.I tried the above code without using "DriverID=22;READONLY=true".Then also it is not working.Is there any issue in accessing MS access in remote location?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with connection to remote access database