image\cslogo3d1.gif

Migrating a Microsoft Access Database to dBase

Microsoft Access databases are compatible with Chili!Soft ASP running on Windows NT, but these databases do not run on Linux or UNIX systems. You have two options for connecting to a Microsoft Access database with Chili!Soft ASP for Linux or UNIX.

First, you can use SequeLink. The necessary steps for creating the connection string are described in "Creating Connection Strings" in this chapter. The steps the system administrator must take are described in "Configuring SequeLink" in "Chapter 3: Managing Chili!Soft ASP."

Alternatively, if you use FrontPage, you can easily migrate your Microsoft Access database to dBase by using the Microsoft Access Export Table feature. You can then import the resulting folder of files to your FrontPage Web and use the Database Results Wizard. The dBase database management system is relatively easy to learn and use.

If you have moved a dBase-based Web application to UNIX and then find that Chili!Soft ASP cannot open the database, make sure that file extension of your dBase files are in all capital letters (i.e., *.DBF).

Note

dBase databases do not support multi-table joins on UNIX.

See also:

Connecting to a Database in this chapter

Using FrontPage Database Featuresin this chapter

Copyright 2001 Sun Microsystems, Inc. All rights reserved. Legal Notice.