NetBeans Database Connectivity Error with Ms Access

Asked By 0 points N/A Posted on -

I am using NetBeans for java work. I want to develop 1 application. In that application I want to get some data from database. For database access I don’t want to use SQL or Oracle. I want to use MS-ACCESS because those peoples are not computer expert so they don’t have knowledge about SQL or Oracle. Now I am having one problem.

I Select Start – Settings – Control Panel – Administrative Tools – Data Sources

(ODBC). And then I click new data source and then I select Microsoft Access Driver(*.mdb) and then I try to get data from Ms-Access file but I can’t get success. Any one tell me its solution.

Answered By 0 points N/A #124757

NetBeans Database Connectivity Error with Ms Access



I have read your problem. i have done the same thing many times. but i didn't get any problem like this. I am repeating the steps.

  • First save your database file in any drive.
  • Go to control panel->administrative tools->data source(ODBC)->System DSN->microsoft Access Driver(.mdb).
  • Give Data source Name and then click on select.
  • Select the location where your access file is saved. Choose the drive. click on the file in left side and ok.
  • Your DSN will be created. make sure our file extension should be mdb.

Now can use this DSN in your source file. it will 100% run.

Also check the name of your DSN on the system Dsn page. I think you done the half work because you specify the half process in your question.

For ex-

Connection con=DriverManager.getConnection("Jdbc:Odbc:mydsn1");

I am attaching one java page of connection.

Related Questions