ONE Active Server Pages Product Home Page Developer Site Version


Using FrontPage Database Connections

To create a database connection in FrontPage, you must enter information about the database, such as its name, ODBC driver, username, and password. FrontPage then writes this information to the global.asa file as a connection string.

However, connection strings must be constructed according to the ODBC driver being used, and the ODBC drivers are different on UNIX and Linux than on Windows. For this reason, before you can use Windows connections with Sun ONE Active Server Pages for UNIX or Linux, you may need to first edit them so they use the syntax described in Creating Connection Strings.

In addition, when you use Microsoft SQL Server 6.5 or Microsoft Access databases with Sun ONE ASP for UNIX or Linux, you must use system DSNs in connection strings; you cannot use DSN-less connection strings or file DSNs. To use a system DSN for connecting to a particular database, your administrator must create a DSN for the database on the ASP Server. In addition, for SQL Server 6.5 and Access, your system administrator must configure SequeLink, as described in Configuring SequeLink.

When you are using Sun ONE ASP for UNIX or Linux, consider migrating your Microsoft Access databases to MySQL, as described in Database Publisher, or to dBASE, as described in Migrating an Access Database to MySQL or dBASE. dBASE is relatively easy to learn and use and eliminates some of the platform compatibility problems you might otherwise experience.

For Microsoft SQL Server 7.0 or 2000 databases, in addition to system DSNs, you can also use DSN-less connection strings and file DSNs. You should verify that your connection strings follow the syntax described in Creating Connection Strings.

For all other databases supported by Sun ONE ASP, you can use system DSNs, file DSNs, and DSN-less connection strings.

See also:

Using FrontPage Database Features

Connecting to a Database