• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC/ODBC MS Access connection

 
Carey Brown
Ranch Hand
Posts: 1391
16
Eclipse IDE Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've got MS Access and haven't been able to figure out how to set up a JDBC/ODBC bridge to connect to it. Is there something other than the JDKSE that I need to down load? What driver and connection code do I need to run?
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have this little program that I use when I want a quick "how to" jdbc lookup. This is the entire program that connects to an access database. The only thing you need to do is to install the jdk(1.3 is what I'm using) and the jvm. Here it is:

where "C:\\Temp\\data\\emp.mdb" is the path to the mdb(emp.mdb in this case) plus escape characters for the \ characters and "username"&"password" are the username and passwords that I set up in Access for security.
and no, you don't have to set up a DSN and all that hassle, this is a DSNless connection to access
Jamie
 
Carey Brown
Ranch Hand
Posts: 1391
16
Eclipse IDE Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A big THANKS. That was exactly what I needed. It worked great!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic