...
Windows System DSN
| Download | This driver is included with Java (Java 7 only) |
|---|
| Driver class | sun.jdbc.odbc.JdbcOdbcDriver |
|---|
| JDBC URL | jdbc:odbc:DATABASE_NAME Where DATABASE_NAME is the database name from your System DSN settings. |
|---|
Windows System DSNless
| Download | This driver is included with Java (Java 7 only) |
|---|
| Driver class | sun.jdbc.odbc.JdbcOdbcDriver |
|---|
| JDBC URL | jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=PATH_TO_MICROSOFT_ACCESS_DATABASE_FILE;
Where PATH_TO_MICROSOFT_ACCESS_DATABASE_FILE is the absolute path to the location where a local database file created in Microsoft Access is stored. For example, if you have a MS Access database file that is named testDB.mdb and saved in the C: drive, you would use the URL
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/testDB.mdb; |
|---|
SQLServer
Microsoft's JDBC driver download for SQL Server comes with two jar files—sqljdbc.jar and sqljdbc4.jar—for two different versions of Java. sqljdbc4.jar (the newer one for Java 6 and later) is the one that you need to add to the JDBC driver preferences.
...