Unable to create ActiveX component

"System. Exception: ActiveX components cannot be created"
Http://tb.blog.csdn.net/TrackBack.aspx? Postid = 855272
A new win2k3 machine, iis6.0. When running a page that uses Excel automation, the following error occurs.

Select distinct WSN from vbapplication. DBO. wf_lifactview where Ws = 'access08family-D161-4DD7-A166-6DA76630600F '; select * From vbapplication. DBO. wf_lifactview where Ws = 'acc08family-D161-4DD7-A166-6DA76630600F 'and Li =' % 'and [year] = 2006 and [month] = 1system. exception: ActiveX components cannot be created. In Microsoft. visualBasic. interaction. createobject (string progid, string servername) in ASP. report_wf_lireport_aspx.page_load (Object sender, eventargs e) Location D: \ portalxp \ report \ WF \ lireport. aspx: the path of row 67 cannot be blank. Parameter Name: Path

In fact, this error is caused by the absence of an Excel process instance in the IIS account. You only need to perform the following steps.

1. Install Office

2. Start dcomcnfg.exe and start the component service.

3. In component service, choose console root directory> component service> Computer> my computer> DCOM configuration> Microsoft Excel application.ProgramRight-click Properties to open the Properties window.

4. On the Security tab, configure the start and activation permissions and add the full permissions for starting the IIS process account.