Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!