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.
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.
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.