This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 175039 - Netbeans 6.5 Error setting up a MS access database
Summary: Netbeans 6.5 Error setting up a MS access database
Status: RESOLVED WONTFIX
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: PC All
: P4 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-20 18:27 UTC by stache01
Modified: 2009-10-20 20:07 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description stache01 2009-10-20 18:27:00 UTC
What is the syntax for the URL field in the "new Connection" window?
Hope you can provide some incite, Thanks for trying in advance.
I have netbeans 6.5 loaded on a PC, with XP 5.1 sp2, MS Access 2003. 

From the IDE, I go to services, right click databases, new connection.
I Select JDBC-ODBC Bridge in the new connection window. I have found some guesses for the format of the URL field to
select an existing MS access database on the web. Here are three guesses which all fail. 
1) jdbc:odbc:MS Access Database;DBQ=h:\\Projects\\access03db.mdb;
   Unable to obtain schema. Driver message:[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented.
2) jdbc:odbc:MS Access Database;DBQ=h:\\Projects\\access03db.mdb;
   con=DriverManager.getConnection(url,"","");
   Unable to add connection. Cannot establish a connection to jdbc:odbc:MS Accesss
     Database;DBQ=..
   con=DriverManager.getConnection(url,"",""); using sun.jdbc.odbc.JdbcOdbcDriver([Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified).
3) Database=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access
Driver(*.mdb)};DBQ=h:\\Projects\\access03db.mdb","","");
   Unable to add connection. Cannot establish a connection to Database=DriverManager.getConnection("jdbc:odbc:Driver=...
   Using Using sun.jdbc.odbc.JdbcOdbcDriver (Unable to find a suitable driver).

4) I right click on the Divers node. I select new driver per the helps. There is no entry in the driver node. I click
the add button, nothing. I click the Find button and it brings up local directory that is meaningless. I do not know
where in the MS file system the driver is located or what its real name is. I searched for a driver on the web, but
could not find one.
Comment 1 Jiri Rechtacek 2009-10-20 20:07:07 UTC
The MS Access database is not supported in latest NetBeans IDE. Check out the site
http://devapp.sun.com/product/jdbc/drivers where you can find a driver for MS Access or look at
http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html where is a guide how to connect that database. Hope
it helps.