Competetor

Competetor

  • 1.1k
  • 672
  • 36k

Microsoft.ACE.OLEDB connection timeout

Jan 16 2019 4:30 AM
I am using excel template to export/import data to sql server table in asp.net. My code is working fine in my local system. I can write data to excel template and read data from the template to save to sql server table even if the number of rows increases. My application is hosted in "Windows Server 2017 Standard Evaluation". There is no problem on writing and reading data to excel template from the online application hosted in the server if the number of rows is less. But if the number of rows increases, I cannot write to excel file and only empty excel template is downloaded. And also I cannot read data from excel if the number of rows increases. Moreover, no error is generated to check the issue. Can anyone help me to solve my issue? It may be due to connection timeout. I have already tried some solutions but could not solve my problem. I would like to thanks in advance for any working solution for my problem.

Answers (2)