Using ASP Queries When SSL Is Enabled Gives Incomplete Results or Errors (164073)

We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

SYMPTOMS

When you do an ODBC query to a database using Active Server Pages (ASP), or you run a large ASP file while security is enabled using Secure Sockets Layer (SSL), you may receive incomplete results or random errors may be generated in Internet Explorer.

This behavior is random. You may be able to run the query with all records reported, but when you click refresh in the browser window the symptoms mentioned in the preceding paragraph may occur.

WORKAROUND

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

Run Registry Editor (Regedt32.exe) on the Internet Information Server computer.
Go to the following key in the registry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ W3SVC\ASP\Parameters

On the Edit menu, click Modify to change the following entry:

      Value Name: BufferingOn
      Value:      1

Exit Registry Editor. You do not need to restart the computer for the change to take effect.

MORE INFORMATION

The BufferingOn flag controls whether Active Server Pages buffers output to a browser. If the flag is on (set to 1, rather than the default value of 0) then all output is collected before any is sent to the browser. This allows HTTP headers to be set from anywhere within a script. The Response.Buffer method can be used to override this default setting. Changing the BufferingOn setting does not require you to stop and restart the Web server for the change to take effect.