JDBC-ODBC - Creating DSN for MS Access

This section describes how to create a DSN that connected to a MS Access database file.

In order to use the JDBC-ODBC Bridge driver, you need to create a DSN (Data Source Name) representing an ODBC connection to a particular database server. This tutorial will show you how to create DSN for a MS Access database file, assuming that it has been created on your local system as described in the previous tutorial.

1. On my Windows 7 system, run Control Panel > Administrative Tools > Data Sources (ODBC).

2. Click the System DSN tab. Then click the Add button.

3. From the ODBC driver list, select Microsoft Access Driver (*.mdb), ODBCJT32.DLL, and click the Finish button.

4. Now fill in the DSN header information as below:

Name: HY_ACCESS
Description: DSN for the HY_Access.mdb
Select Database: HY_Access.mdb

5. Click OK. My DSN "HY_ACCESS" is ready now.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Microsoft SQL Server Express Edition

 Microsoft JDBC Driver for SQL Server

 Microsoft JDBC Driver - Query Statements and Result Sets

 Microsoft JDBC Driver - DatabaseMetaData Object

 Microsoft JDBC Driver - DDL Statements

 Microsoft JDBC Driver - DML Statements

 SQL Server - PreparedStatement

 SQL Server CLOB (Character Large Object) - TEXT

 SQL Server BLOB (Binary Large Object) - BLOB

 JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

 JDBC-ODBC Bridge Driver - Flat Text Files

JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC - Creating a MS Access Database File

JDBC-ODBC - Creating DSN for MS Access

 JDBC-ODBC - Connecting to MS Access Database Files

 JDBC-ODBC - MS Access Database and Driver Info

 JDBC-ODBC - Creating New Tables in MS Access Database

 JDBC-ODBC - Inserting Data Rows to MS Access Database

 JDBC-ODBC - Running Queries on MS Access Database

 Creating Connections with DataSource Class

 JDBC-ODBC Bridge Driver - MS SQL Server

 Archived Tutorials

 References

 Full Version in PDF/EPUB