NetBeans Database Connectivity Error with Ms Access

Asked By juliemackown 0 points N/A Posted 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.

• Status: Open
• Question Views: 1473
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By honey.garg 0 points N/A #124757

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.

About honey.garg

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 11/22/2011
• Question Category: MS Access