Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What do I need to use Access with JDBC

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to pick up JDBC and have no access to any SQL db. Can I use Access as the db ??? What do I need to do to set up an Access db as my data source?? What drivers would i need to install?? I am a db novice and would appreciate advise that is sorta like the "for dummies..." :-) Thank You.
 
Justin Moore
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
u can set up an Access db as a ODBC datasource then use the ODBC-JDBC bridge driver
your best bet is to go thru the Sun Java tutorial at http://web2.java.sun.com/docs/books/tutorial/jdbc/index.html
 
siva kumar
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
use jdbcodbcdriver.createdatabase in access in that create
a table.create one DSN name (32bit odbc).bind ur database
with the dsn name.do asusual ur jdbc program.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic