The following errors might occur at runtime when using EasyXLS Excel library for Classic ASP and VBScript:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
at line:
Server.CreateObject("EasyXLS.ExcelDocument") Possible reason #1: Windows 64-bit, IIS Server and EasyXLS.dll for 64-bitIf the EasyXLS version for 64-bit is used on a Windows 64-bit operating system, make sure that IIS allows running of 64-bit applications. Open Internet Information Services (IIS) Manager in Control Panel/Administrative Tools. Select Application Pools and the application pool associated with your web application.
![IIS Application Pools]()
Select Advanced Settings and check if Enable 32-bit Application option is set to false.
![IIS 64-bit applications]()
Possible reason #2: Windows 64-bit, IIS Server and EasyXLS.dll for 32-bitIf the EasyXLS version for 32-bit is used on a Windows 64-bit operating system, make sure that IIS allows running of 32-bit applications. Open Internet Information Services (IIS) Manager on Control Panel/Administrative Tools. Select Application Pools and the application pool associated with your web application.
![IIS Application Pools]()
Select Advanced Settings and check if Enable 32-bit Application option is set to true.
![IIS 32-bit applications]()
Possible reason #3: IIS Server and permissions on .NET componentsThe authenticating identity of the site has to match the identity of the application pool, otherwise IUSR user does not have enough permissions. If the site uses a "Specific user", switch to use "Application pool identity".
1. Open Internet Information Services (IIS) Manager in Control Panel/Administrative Tools. Select your site and double-click "Authentication".
![IIS Application Properties]()
Select "Anonymous Authentication" and press "Edit...".
![IIS Authentication]()
Choose "Application pool identity"
![IIS Anonymous Authentication Credentials]()
2. Select Application Pools and the application pool associated with your site.
![IIS Application Pools]()
Select Advanced Settings and check if Identity is set to ApplicationPoolIdentity.
![IIS Process Identity]()
3. Optionally, you can check if the site connect as "Application user". Select your site, "Basic Settings...", press "Connect as..." button and verify if "Application user (pass through authentication) is selected. Possible reason #4: Another EasyXLS.dll previously registered and IIS ServerIf another version of EasyXLS.dll was registered, by installer or manually using regsvcs command, IIS Server must be restarted.
It is recommended to delete EasyXLS from Component Services, before registering another EasyXLS.dll. By uninstalling EasyXLS, EasyXLS component is deleted from Component Services by default. See How to register EasyXLS for details about opening Component Services and how to manually register EasyXLS.dll.
Possible reason #5: Windows 64-bit, web server or VBScript application running on 64-bit and EasyXLS.dll for 32-bitIf the EasyXLS version for 32-bit is used on a Windows 64-bit operating system, make sure that the application that runs EasyXLS code allows running of 32-bit applications. If not, install EasyXLS version on 64-bit. Possible reason #6: Windows 64-bit, web server or VBScript application running on 32-bit and EasyXLS.dll for 64-bitIf the EasyXLS version for 64-bit is used on a Windows 64-bit operating system, make sure that the application that runs EasyXLS code allows running of 64-bit applications. If not, install EasyXLS version on 32-bit. Contact us for any other reasonsIf none of the above, contact us at support@easyxls.com with details about your application configuration and the full error message. |