Microsoft Access databases are compatible with Sun Chili!Soft ASP running on Windows, but these databases do not run on UNIX or Linux systems. You have two options for connecting to a Microsoft Access database with Sun Chili!Soft ASP for UNIX or Linux.
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 Sun 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 Sun Chili!Soft ASP cannot open the database, make sure that the file extensions of your dBASE files are in all capital letters (that is, *.DBF).
dBASE databases do not support multi-table joins on UNIX.
Connecting to a Database in this chapter
Using FrontPage Database Features in this chapter
Copyright 2002 Sun Microsystems, Inc. All rights reserved. Legal Notice.