Support Database
Important ASP information for Frontpage users

You cannot create ASP pages directly on Domainscape Internet servers with Sun ONE Active Server Pages. You must create any ASP pages generated by the Database Results Wizard on your local workstation (by using a disk-based Web, Personal Web Server, or Internet Information Server). After the pages are published to the remote server running Sun ONE Active Server Pages and the FrontPage Server Extensions, you can use FrontPage to alter the ASP or HTML pages directly.

To use MySQL with Sun ONE Active Server Pages, you'll need to download and install the ODBC driver (full version) appropriate for the operating system you're running.

The Database command on the Insert menu in FrontPage is not activated when you perform remote authoring. To edit part of your database results region after publishing it, make the adjustment to your local copy and re-publish the changes.

Remember to use "DSN-less" connections.

Sun ONE Active Server Pages does not support UDL connection. Use DSN files instead.

If you are creating or using a connection based on the Custom Definition option within FrontPage 2001 or later, do not use hard-coded paths to refer to file-based databases or file DSNs. Instead, use the URL= web-relative path.

Remember that our servers are case-sensitive. Make sure that all data source connections and SQL statements accurately reflect the case of the file names and table/field names involved.

Microsoft Access databases do not run with Sun ONE Active Server Pages on Domainscape Internet servers. You may use MySQL databases instead. It is possible to convert Access databases to MySQL databases using the Access Export Table feature. Perform this conversion before using the Database Results Wizard, or re-run the Database Results Wizard after the conversion, choosing a new connection to the converted data. Note that FrontPage uses Microsoft Access file format for its sample database and for databases it creates for use with the Save to Database feature.

CreateObject ("Scripting.FileSystemObject") calls generated by FrontPage will not work. Therefore, you must change the code generated by FrontPage in the Global.asa file to Server.CreateObject("Scripting.FileSystemObject").