FP: Confirmation Page Appears But No Data Is Added to Database

When you click the Submit button on a Web page that has a form that is set up to save data to a database, you receive a confirmation page, but no data is added to the database. You do not receive an error message.

This situation may occur if you have turned off session state in the application settings on your Microsoft Internet Information Services (IIS) Web server.

To resolve this issue, turn on session state in your application settings. To do this, follow these steps:

1. Open the Internet Services Manager. To do this, follow the steps for your version of IIS.
   • For IIS 4.0:
     1. Click Start, point to Programs, and then click Windows NT 4.0 Option Pack.
     2. Click Microsoft Internet Information Server.
     3. Select Internet Service Manager.
   • For IIS 5.0:
     1. Click Start menu, point to Programs, and then click Administrative Tools.
     2. Select Internet Services Manager.
   • For IIS 5.1:
     1. Start Control Panel.
     2. Double-click Administrative Tools.
     3. Double-click Internet Information Services.
2. Turn on session state for the affected application. To do this, follow the steps for your configuration.
   • For a Web site:
     1. Right-click the Web site, and then click Properties.
     2. Click the Home Directory tab, and then click Configuration.
     3. Click the App Options tab or the Options tab.
     4. Check the Enable session state box, then click OK.
     5. Click OK to close the Web site's properties dialog box.
   • For a subweb:
     1. Right-click the folder for the subweb, and then click Properties.
     2. Click the Directory tab, and then click Configuration.
     3. Click the App Options tab or the Options tab.
     4. Check the Enable session state box, and then click OK.
     5. Click OK to close the subweb folder's properties dialog.
3. Close the Internet Services Manager.

NOTE: You may have to restart your Web services to reflect these changes.

For more information on related FrontPage issues, click the following article numbers to view the articles in the Microsoft Knowledge Base:

For additional information on configuring session state options in IIS and related errors, click the article numbers below to view the articles in the Microsoft Knowledge Base: