Solve the Server. CreateObject error of Asp program

Since I have never used the xp system before (I used it when I first came out of college, but I never used xp in the future. At that time, I didn't like the wonderful interface .), I have never encountered such a problem. I am helping a netizen mm solve the problem of importing excel to the sqlserver database today, the asp code does not have the permission to create an excel Object (even in the English version of XP Professional), which is probably the problem of xp default permission restriction. So I searched Baidu and found the solution as follows:

Many people who use IIS often encounter similar problems.

An error occurs when the Asp program creates an object. The general content is the Server Object error 'asp 0178: 8080', which usually occurs on a later version of IIS or Windows.
If you are using a Chinese version, the error message is as follows:

Program code:
Server Object error 'asp 0178: 66661'

Server. CreateObject Access Error

../Config/coon. asp, Row 5

Failed to call Server. CreateObject when checking the permission. Deny access to this object.

If the English version is used, the error message is as follows:

Program code:
Error Type:
Server object, asp 0178 (0x80070005)
The call to Server. CreateObject failed while checking permissions. Access is denied to this object.
../Config/coon. asp, line 5

Solution:

1. An error occurs when "server. createObject (" mssearch. application ")" is called. The solution is as follows:

Start> RUN> dcomcnfg

Find "mssearch" (the name depends on what the Object is called), right-click "Properties", and choose "security" to grant all three permissions to everyone. In fact, the first permission is enough.

2. When the above problem occurs, the reason is indeed the permission problem.

One solution is to modify the IIS Anonymous access permission.

The second simplest way is to register your components from another place, especially not to some special directories on the desktop or C disk (System Disk). Instead, you should register your components in a directory such as D, e. The reason is that the accounts used by your IIS are generally accounts with low system permissions. If you log on with your own account, the desktop access permission may be higher than that of the IIS account.

3. Check the MS database. The solution is as follows:

This article was previusly published under Q315454
SYMPTOMS
When you attempt to browse to an Active Server Page (ASP) database results page created in Microsoft FrontPage, you may receive an error message similar to the following:
Program code:
Server object error 'asp 0178: 100'

Server. CreateObject Access Error

../Config/coon. asp, line 5

The call to server. Createobject failed while checking permissions. access is denied to this object.
Cause
This behavior can occur if incorrect NTFS permissions are defined for your "% ProgramFiles %/common files/system" folder.
Resolution
To resolve your issue, reset the NTFS permissions on the "% ProgramFiles %/common files/system" folder. To do this, follow these steps:
1. Open Windows Explorer. To do this, right-click Start and then click shortcut E on the shortcut cut menu.
2.. in folders view, expand the "% ProgramFiles %/common files/system" folder.
3. Right-click the folder and click Properties on the shortcut menu.
4. Click the Security tab.
5. Add everyone to the existing permissions, give at least read permissions to everyone, and apply these new settings to all files and subfolders.
6. Click OK.