• 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: 20971
31
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