Previous PageNext Page

E.2.1 File/Folder Database Connections

FrontPage supports direct access to database files for file-based databases such as Access, dBase, FoxPro, Excel, Paradox, Excel, .txt, .csv, etc. FrontPage constructs a Connection String for the file and stores it in Global.asa. The following example shows the ASP code written to Global.asa for a dBase database:
 

Application("InvSampInWeb_ConnnectionString") = "DRIVER={Microsoft dBase Driver (*.dbf)}; DefaultDir=URL=invsamp/"

The "URL=" parameter signifies that the DefaultDir is a Web-relative path. Script in Global.asa maps this relative path to an absolute file system path required by the driver.
 

Note:

Excel file connections are not supported on UNIX or Linux. Chili!Soft ASP for UNIX/Linux can connect to an Access database, but the Access database must reside on Windows NT.


Copyright © 2000 Chili!Soft

Previous PageTop Of PageNext Page