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.
hi, i am useing the netbeans for the first time n i am trying to connect to a MS Access DB through the wizard but i am not able to. I entered: Name:JDBC-ODBC Bridge. Driver: sun.jdbc.odbc.JdbcOdbcDriver Database URL: jdbc:odbc:Driver={Microsoft Access Driver (.*mdb)};dbq=C:\Users\Vamsi\Documents\PIN.mdb; the issue its giving is: Unable to add connection. Cannot establish a connection to :jdbc:odbc:Driver={Microsoft Access Driver (.*mdb)};dbq=C:\Users\Vamsi\Documents\PIN.mdb; Using sun.jdbc.odbc.JdbcOdbcDriver[Microsoft][ODBC Driver Manager]datasource name not found or no default driver specified) I have also created a System DSN of the name PIN.mdb in the Contol panel > Administrative tools > Data sources(ODBC). please help me if i am missing something or hve done something wrong.
Reassigned to new owner.
Jirko, have you MS Access in your configuration? Could you try it and provide any help how to solve it? Thanks
Created attachment 89976 [details] Sample MS Access DB
I tried it with NetBeans 6.8 and it works with Nwind.mdb sample DB with the following URL: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Development\DB\MSAccess\Nwind.mdb While connected I found an issue with browsing tables which I fixed (core-main #146bcbfd1e4e). Please, wait for new daily build which will be announced in this issue and try again with Nwind.mdb. It should work.