This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with connection to remote access database

 
Abey Thampy
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20763
30
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Quite likely. Why don't you tell us about your problem? (Read our FAQ entry TellTheDetails for more about that.)
 
Abey Thampy
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic