• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • paul wheaton
  • Ron McLeod
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:

Problem with connection to remote access database

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Sheriff
Posts: 28394
100
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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("jdbc:odbc:Driver={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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic