(Solved) Error: Server.CreateObject Failed - Classic ASP in IIS

Error:
Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed

C:\INETPUB\WWWROOT\TestApp\AUTHENTICATION\../serverlib/global.asp, line 190

800401f3

Solution with Sample code:

• Open the error file and go to the corresponding line (here 190)

if (!sleep.waiter) sleep.waiter = Server.CreateObject("WaitFor.Comp"); // error line
sleep.waiter.WaitForSeconds(sleepSeconds);

• Get the Waitfor component file location.
• Run command prompt as Administrator.
• Execute the below command 

C:\Windows\system32> regsvr32 "C:\inetpub\wwwroot\TestApp\serverlib\components\WaitFor\waitfor.dll"

Note: WaitFor is a component used here.

Convert Excel file Stream to DataTable in C# .NET

Using ExcelDataReader library we can convert a file stream excel file to a DataTable. The excel file no need to be saved to the local drive. The sample code is given below.

    byte[] buffer = Convert.FromBase64String(fileData.Replace(' ', '+'));
 
    Stream stream = new MemoryStream(buffer);
 
    var result = this.ExcelStreamToDataSet(stream);

public DataSet ExcelStreamToDataSet(Stream stream)
{
    IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
 
    excelReader.IsFirstRowAsColumnNames = true;
 
    var ds = excelReader.AsDataSet();
 
    excelReader.Close();
 
    return ds;
}