This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Netbeans and MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Netbeans and MS Access" Watch "Netbeans and MS Access" New topic
Author

Netbeans and MS Access

catherine matthews
Ranch Hand

Joined: Jan 22, 2006
Posts: 78
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

Joined: Mar 28, 2008
Posts: 54
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


Dale Carnegie:<br />"Most of the important things in the world have been accomplished<br />by people who have kept on trying when there seemed to be no hope at all."
 
GeeCON Prague 2014
 
subject: Netbeans and MS Access