N/APosted on - 09/18/2011
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.
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.
I am attaching one java page of connection.