Java Programming/Database Programming

< Java Programming
Networking Java Programming
Database Programming
Navigate Advanced topic: v  d  e )

Connecting to MS Access databasesEdit

The following is used to open an ODBC connection to an Access database. Note that the username (and password, if applicable) are given in the dsn rather than the getConnection call. This is a MS Windows-only example, due to the requirement for the Microsoft Access Driver.

String path = "C:/example.mdb";
String dsn = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + path + ";UID=admin";
accessConn = DriverManager.getConnection(dsn, "", "");
Read in another language