Microsoft KB Archive/265161

= You receive an error message when you try locate an ASP database result page that was created in FrontPage =

Article ID: 265161

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft FrontPage 2002 Standard Edition
 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q265161



SYMPTOMS
When you try to locate an Active Server Page (ASP) database results page that was created in Microsoft FrontPage, you may receive an error message that is similar to one of the following:

Error #1:

Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object

/_fpclass/fpdbrgn1.inc, line 99

Note This error message may be followed by a description of why the resource was inaccessible.

Error #2:

Execute Access Denied

This Virtual Directory does not allow objects to be executed.

Error #3:

Database Results Error

The database connection named 'Sample' is undefined.

This problem can occur if:


 * the connection has been removed from the web.


 * the file 'global.asa' is missing or contains errors.


 * the root folder does not have Scripting permissions enabled.


 * the web is not marked as an Application Root.



CAUSE
This problem may occur if the following respective conditions are true:

Error #1:

The NTFS file systems permissions are defined incorrectly for the %ProgramFiles%\Common Files\System folder.

Error #2:

The virtual directory that you are connecting to is not marked as an ASP program.

Error #3:

The virtual directory that you are connecting to does not have at least Script permissions defined in the Microsoft Internet Information Service (IIS) settings.



RESOLUTION
Note We strongly recommend that you upgrade to Microsoft Internet Information Services (IIS) 6.0 running on Microsoft Windows Server 2003. IIS 6.0 helps increase 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

To resolve this problem, use the method appropriate to the error message you are receiving:

Error #1:

Reset the NTFS permisions on the &quot;%ProgramFiles%\Common Files\System&quot; folder. To do this, follow these steps:
 * 1) Right-click Start, and then click Open to start Microsoft Windows Explorer.
 * 2) Expand the %ProgramFiles%\Common Files\System folder in Folders view.
 * 3) Right-click the folder, and then click Properties.
 * 4) Click the Security tab.
 * 5) Add Everyone to the exisiting permissions with at least Read permissions and apply these new settings to all files and subfolders.
 * 6) Click OK.

Error #2:

Mark the folder as an Application Root. To do this, follow these steps:  Start Internet Services Manager. To do this, follow the steps for your version of IIS.  For IIS 5.0, for IIS 5.1, and for IIS 6.0:  Click Start, and then click Run. Type %windir%\system32\inetsrv\inetmgr.exe in the Open box, and then click OK.  For IIS 4.0:  Click Start, point to Programs, and then click Windows NT 4.0 Option Pack.</li> Click Microsoft Internet Information Server.</li> Click Internet Service Manager.</li></ol> </li></ul> </li> Expand the path to the folder in Tree view.</li> Right-click the folder, and then click Properties.</li> Click the Directory tab or click the Home Directory tab.</li> Click Create.</li> Click OK.</li></ol>

Error #3:

Configure the folder to have at least Script permissions. To do this, follow these steps:  Start Internet Services Manager. To do this, follow the steps for your version of IIS: <ul> For IIS 5.0, for IIS 5.1, and for IIS 6.0:  Click Start, and then click Run.</li> Type %windir%\system32\inetsrv\inetmgr.exe in the Open box, and then click OK.</li></ol> </li> For IIS 4.0: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to Programs, and then click Windows NT 4.0 Option Pack.</li> <li>Click Microsoft Internet Information Server.</li> <li>Click Internet Service Manager.</li></ol> </li></ul> </li> <li>Expand the path to the folder in the Tree view.</li> <li>Right-click the folder, and then click Properties.</li> <li>Click the Directory tab or click the Home Directory tab.</li> <li>Select Scripts only for the execute permissions.</li> <li>Click OK.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
If you are trying to gain access to a Microsoft Access database, make sure that you have established the appropriate permissions. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

187506 Required NTFS permissions and user rights for IIS 4.0

When a user tries to perform an Internet Database Connector (IDC) or ActiveX Data Objects (ADO) query, the query is run in context of the authenticated Web user. Typically, you (the FrontPage Web developer) might grant the directory permissions listed later in this article to an anonymous user or to the authenticated Microsoft Windows NT user account. (By default, the anonymous user is IUSR_ .)

When you apply these permissions, apply them to all existing files unless otherwise noted.

When you set permissions for the IUSR account, you need to add all user accounts that need to be authenticated on the Microsoft Internet Information Server (IIS) computer.

The directories identified in the sixth and seventh bullets that follow are located by default in the Program Files/Common Files/System directory and are needed only for ASP and ADO queries.

Typical permissions for IUSR are as follows:
 * Read permission to the root directory of the drive on which ASP is installed.
 * Write permission to the Windows NT directory in Windows NT, or to the WinNT directory in Windows 2000.
 * Read permission to the System32 directory.
 * Read permission to the Inetsrv directory.
 * Read permission to the InetPub (or content directory).
 * Read permission to the OLE DB directory.
 * Read permission to the ADO directory.
 * Change permissions to the database file and directories.

Note The Microsoft Jet database engine uses the System Temp and Tmp environment variables to specify the location of temporary files that are created during Jet operations. By default, these environment variables are defined for users and are not system-wide settings. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

315456 You receive a database results error when you connect to database from an ASP page

<div class="references_section">