Tuesday 21 May 2013

Configure the ODBC Settings for jdbc odbc connectivity

Administrative Tools >> Datasources(ODBC)

  • Click the System DSN tab, and click Add to create a new data source. The Create New Data Source window appears.

  • Select Microsoft Access Driver (*.mdb) and click Finish. The ODBC Microsoft Access Setup window appears.
  • Data source name is used everywhere in jdbc coding example

    Connection con = DriverManager.getConnection("jdbc:odbc:student");
      our d.s.n is student .
  • it is name of your selected access db

  • Under Database, click the Create button to create your database. The New Database window appears.

No comments:

Post a Comment