JDBC for SQL Server - Herong's Tutorial Examples - v3.14, by Herong Yang
JDBC-ODBC - Creating DSN
This section describes how to create a DSN quick to test JDBC-ODBC Bridge.
The quickest way to test JDBC-ODBC Bridge is to create a DSN (Data Source Name) for a flat file, then use this DSN in the JDBC connection URL. Here is how I created a DSN to represent flat text files:
1. Run Control Panel > Administrative Tools > Data Sources (ODBC).
2. Click the "User DSN" tab. Then click the Add button.
3. From the ODBC driver list, select Microsoft Text Driver (*.txt, *.csv), ACEODBC.DLL or ODBCJT32.DLL, and click the Finish button.
4. Now fill in the DSN setup information as below:
Name: HY_DSN Description: DSN for a flat file Use Current Directory: checked
5. Click OK. My DSN "HY_DSN" is ready now.
Notice that I did not specify any specific file for the DSN.
Table of Contents
JDBC (Java Database Connectivity) Introduction
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
Using Connection Pool with JDBC
►JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC Bridge Driver Features
JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC - Connecting to a DSN
JDBC-ODBC - Problem with Incorrect DSN
JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access