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

HELP!!!

 
fengzixuan zheng
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got a problem, I want connect to a MS Access database, and I found when I get connected, I only can use the READ_ONLY concurrency, HOW I CAN MODIFY the Access database? Help. Please.
By the way, can I create a connection without building a 32-bits database source in the Windows, I need to imagrate the app programs to another computer.
Thanks !
[This message has been edited by fengzixuan zheng (edited August 18, 2001).]
 
Gary Labowitz
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use CONCUR_UPDATABLE constant in the createStatement() method. This is only since 1.2, so if you are using the jdbc/odbc driver from 1.1x you are out of luck.
BTW, you don't even need a DSN; just use
url = "jdbc dbc:MS Access Database;DBQ=path-to-database"
Gary
 
fengzixuan zheng
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
THANK U, Labowitz
But I'm using JDK1.3, I will try again .
What database do U suggest to use when developing a databased-project ?
Thank U again!
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For small projects, MS Access will do fine. But I would suggest using MySQL (www.mysql.com) because it's lightning fast and it's FREE too (and it works on both Windows and *nix).
Good luck!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic