• Post Reply Bookmark Topic Watch Topic
  • New Topic

Netbeans and MS Access

 
catherine matthews
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I could not find much help on how to create dateabse connection with netbeans.

I am trying to access tables in MS Access using the netbeans. Can anyone help??

I tried to add the driver from
Runtime-database-drivers-(JDBC-ODBC-DRIVER)-Connect Using
Name : JDBC-ODBC-BRIDGE
Database URL : jdbc dbc:<DB>

the DB part i put in d:/java/db4.mdb- the path where my database file is
But i could not make a connection


When i run the code below using a command prompt There is no problem

 
Stuart Smith
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Java will connect as its loading a file via JDBC have you added a ODBC connection from the control panel in administrative tools?

As once you have done that Netbeans will be able to find it.
check here http://wiki.netbeans.org/AccessMssql google is your friend
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!