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