File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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."
 
 
subject: Netbeans and MS Access