由于以前一直没用过XP系统(还是在大学那会xp刚出来的时候用过,以后就一直没用过xp,当时不喜欢它花里胡哨的界面,呵呵。),没碰到过这样的问题,今天在帮一个网友mm解决excel导入到sqlserver数据库中遇到这样的问题,asp代码里无权限创建excel对象(偶的是XP Professional 英文版),大概是xp默认权限限制的问题,于是到百度里搜索了一下,找到了解决办法如下:
程序代码: 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
This article was previously 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: 程序代码: Server object error 'ASP 0178 : 80070005'
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 Explore on the shortcut 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.