|
|
Using FrontPage with ASPFollow this FrontPage tutorial to find out how FrontPage offers several features that make it simple to add interactive database connectivity to your Website. You can:
Once a connection is made to a database, FrontPage makes it easy to display data on a Webpage with the Database Results Wizard. By displaying the contents of your ODBC database on a Webpage, users will see the most recent data each time they view and refresh a page. Please contact Netregistry Support if you wish to utilise database features. FrontPage Database FeaturesFrontPage Data ConnectionsFrontPage uses FrontPage Database Connections to specify the name, location, and type of database to access, along with any driver-specific information, user names, passwords, etc. You enter this information in FrontPage, and it is written to the global.asa file as a Connection String. File/Folder Database ConnectionsFrontPage 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. Click here, if you are using Netscape, for an example of the code for an Access Database. Stop, if you are using MicroSoft IE, you will need to click here for an example of the code for an Access Database. Click here, if you are using Netscape, for an example of the code for an Postgres Database. Stop, if you are using MicroSoft IE, you will need to click here for an example of the code for an Postgres Database. 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, please contact Netregistry Support for assistance.. Custom Connections using File DSNsFor assistance with custom connections, please contact Netregistry Support. Users can create File DSNs that connect to ODBC data sources using the Microsoft ODBC Admin tool. Once the resulting *.dsn file is imported to the Web, FrontPage users can create a connection that points to it. Note that if you are using a file-based database such as dBase, your *.dsn file will contain a hard-coded file reference that may not work when moved to a different server. The Connection String constructed by FrontPage would look like: Application("Inventory_ConnectionString") = "File Name=URL=/Inventory_file_dsn.dsn"A File DSN can be stored in protected directories available only to the Chili!Soft ASP server and the user that created it. The use of File DSNs is typically the most secure approach to providing database access on a shared Web server because the File DSN can contain the user name and password for the database, and when Chili!Soft ASP is running in Inherited User mode, it can only open the file containing the DSN if it is running as a user with permission to open the file. Chili!Soft ASP and the FrontPage Server ExtensionsChili!Soft ASP supports FrontPage-generated ASP applications on Linux. Included in the FrontPage package are "FrontPage Server Extensions" that enable users to create Webpages for a variety of Web Servers. You may use Chili!Soft ASP and the FrontPage Server Extensions together with the same Web server. There are two points to remember, however. Contact Netregistry Support from more information on database connectivity, database features and connections using file DSN. Important Facts to RememberRemember the following when creating and deploying FrontPage ASP application Websites with Chili!Soft ASP:
|
Report a bug