Sunday, 13 October 2013

JDBC-ODBC Connectivity [MS Access]

Procedure
1.Go to Control Panel
2.Click Administrative Tools -- Click Data Sources(ODBC)
3. Now ODBC Data Source Administrator Dialog Box gets opened.
4. Now click System DSN, a dialog box appears and then click Add..
5. Create New Data Source dialog box gets opened and then click Driver Do Microsoft Access (*.mdb) and click Finish.
6. When you click finish, ODBC Microsoft Access Setup gets opened
Fill the following information
Data Source Name: MyDatabase (note:any name, which you will be calling in your program)
Description: <anything>
7. Click Select and locate your mdb file
8. Click OK for all opened dialog boxes. You have successfully created a connection for MS-ACCESS

No comments:

Post a Comment