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

MS Access with DSN

 
jamie ong
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Just want to ask is it possible for java application to connect to MS access without configuring the DSN? and if i dont have office install on my machine, can the application still connect to the database?
regards
Jamie.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is how I connect to MSAccess using a dsn-less connection. I believe you will need MSAccess Installed because the jdbc dbc bridge uses its ODBC drivers. Try it with and without to see:

note: spacing matters so just cut and paste your data into this string
Jamie
I had better disable smilies!
[This message has been edited by Jamie Robertson (edited November 12, 2001).]
[This message has been edited by Jamie Robertson (edited November 12, 2001).]
 
jamie ong
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a million for the code!
i tried out to run my program without Office installed and it works. Apparently, the ODBC driver comes with the OS.
i will further test the result on other platform.
Thanks again
Jamie.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic