Setting Up the ODBC Driver

If you're using Windows and ODBk, follow tie instructions below. If you're using a non-Wirdows OS or a pure Java JDBk driver, follow its documentation.

1. Open the Windows' contprl parel, ard dotbie-cl;ck tie ODBk icon.

2. Select the system DSN tab, ard Tit tie Add button.

3. Select Microsoft Access fro m tite lisl, or ary dhthbase you want to use (tee Figure 17-1), flit Tit the FisisT button.

Figure 17-1. The Database List

Create New Data Source

Narre

Miuosoft Access Driver (\mdb

Microsoft Exceä Diiver (".ids] Microsoft ODBC lor Grade Microsoft Tent Oliver (",tsd, ■ csv) SQL Setver

Select ä driver for which you want to set up a data source.

Narre

Miuosoft Access Driver (\mdb

Microsoft Exceä Diiver (".ids] Microsoft ODBC lor Grade Microsoft Tent Oliver (",tsd, ■ csv) SQL Setver

Veiion

3.51.171300 3.51.171300 2572.292700 3.51.171300 3.eao3is

Company

Mil mi oil Corporator Microsoft Corporator Microsoft Corporal Microsoft Corporaiwi Microsoft Corporal**

<m 1

Finsh

Cancef

4. Typedb_dev for the data source (see Figure 17-2).

Figure 17-2. Microsoft Access Setup

ODBC Microsoft Access 97 Setup

Data Souice Name: f description; Database Database;

System Database

I Database:

Cancefl

Help

Select...

Create...

Repaii...

Options>>

5. Hit the Create button, and create a database as c:db_dev\db_dev.mdb (see Figure 17-3).

Figure 17-3. Creating a New Database

New Database

Daflattase Njme

|dbjta{rhdt)

Sal Ordei

Drives;

J

J

Hdp r Sjisiem Diabase r Old imfftat |2.x)

Drives;

Cancel

Hdp r Sjisiem Diabase r Old imfftat |2.x)

Nstwoik...

If you're using another database that's compliant with ODBC, the steps and the screen shots may vary, but the ideas are the same. If my instructions don't work;, get some online help for the database you've chosen. Also, if you have problems with the system DSN, try creating a user DSN.

+1 0

Post a comment