(Solved) Error: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'C:\inetpub\wwwroot\...\Service.svc

Error:

You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'C:\inetpub\wwwroot\...\Service.svc

Solution:

• Give access permission to the "IUSR" in IIS. That should solved the problem.

(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;
}