[Table of Contents]

Introduction to Database-Enabled Web Documents
Requirements for Using Database Wizard
Overview of the Database Wizard
Connecting to Access Database Off-Line
Creating Table Block Showing Table Contents
Fine-tune Web Documents Created by Database Wizard

 

There are 2 ways to connect to database files using Namo WebEditor's Database Wizard. The following example shows the way to connect to access database files.

Connect to Access Database from ODBC Data Source (32bit)

1. Select [Settings > Control Panel] command in the Windows Start menu.

2. Double-click Administrative Tools.

Administrative Tools

3. Select Data Sources (ODBC).

Data Sources (ODBC)

4. Choose System DSN tab in the ODBC Data Source Administrator dialog box.

DSN

5. Press Add button, select Microsoft Access Driver, and press Finish button.

MS Access Driver

6. When ODBC Microsoft Access Setup dialog box appears, enter the name and the description of the data source and press Select... button to select an access file to use.

ODBC Microsoft Access Setup

7. Press Advanced button in the window above, enter login name and password and press OK.

Set Advanced Options

8. After all the steps, you can see the name of access database data source in ODBC Data Source Manager.

ODBC Data Source Administrator

9. In step 2 of the Database Wizard, select an ODBC data source. The drop-down menu lists all User DSNs and System DSNs defined in the ODBC Data Sources control panel. You must select an ODBC data source, even if you selected Built-in-MySQL Driver as the Database connection in Step 1 of the Database Wizard. (This is because Namo WebEditor must connect to the database through ODBC in order to display a preview of the database-enabled document.)
If your Web server will use ODBC to connect to the database, you must use a System DSN.

Data Source

 

Connect Access Database in Database Wizard Menu

1. Select any form you want in Database Wizard, and run the Step 1 of the Database Wizard. At Step 2, select <Make New DSN>.

Nake New DSN

2. In Create New Data Source window, select System Data Source, and press Next button (Please note that you are recommended to select System Data Source item if you selected ASP script at step 1).

Create New Data Source

3. Select Microsoft Access Driver and press Next.

Create New Data Source

4. Check selected driver information and press Finish.

Create New Data Source

The rest is the same as the 4th and after steps of Connect Database from ODBC32 Data Source.

 

Namo Interactive Inc.

This document is created using Namo WebEditor 4 on August 2, 2000.

 

© 2001 Namo Interactive Inc. All rights reserved.