Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc -access

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
I'm using access as database.when we use SQL as database we write import java.sql.*;
but when we use access what are the library functions which we have to import?Can anyone provide me with the code to access Access database.
 
John Bateman
Ranch Hand
Posts: 320
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The code is the same, you just may need another driver. Like the JDBC/ODBC bridge driver.
Hope this helps.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm assuming you're running on a windows machine, first you have to set up your access file to use the odbc drivers (cos access is a file, not an RDBMS)
Go to the control panel, odbc data sources, user dsn tab, add, select *.mdb, finish.
Give the file a name, in the database section browse and select your database.
Once you've done this you should be able to go...

Dave.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I promised myslef I'd never forget to turn smilies off when writing jdbcdbc.
Looks like I failed.

Dave
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic