Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

What do I need to use Access with JDBC  RSS feed

 
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
Boost this thread!