I have a .NET C# web api application hosted inside Azure App Services. This api reads .xls files from blob storage and stores it inside sql database. I am using following connection string to connect to .xls file.
var connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fpath + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;Importmixedtypes=text;typeguessrows=0;\"";
Last week everything was working properly but now I am getting following error
Unexpected error from external database driver (1)
I also tried to change provider from Microsoft.Jet.OLEDB.4.0 to Microsoft.ACE.OLEDB.12.0 in connection string but I found that it is not supported in Azure App Services. MSDN link
I have not changed any code related to this issue. I think the problem is from Microsoft side, they might have run some security updates.
How should I get it fixed. I need help.