how to resolve a aceoledb.dll!GetModuleMsoSynchronizer error

LIU YONG 1 Reputation point
2023-01-16T04:17:57.3833333+00:00

I have a IIS asp program that reads a uploaded Excel file and puts the contents into database.

There is a sample source like below:

	Set connXLS = Server.CreateObject("ADODB.Connection")
	connStrXLS = "Provider=Microsoft.Ace.OleDb.12.0;Extended Properties='Excel 12.0;Imex=1;HDR=Yes';Data Source=" & Server.MapPath(strFilePath)
	connXLS.Open connStrXLS

When I upload excel file for one , two or three times, there is no problem. But when I uploaded excel file for the fourth time or more, it encounted an error and IIS was hanged. I use the ProcessExplorer to try to find the reason and get the result. It is an error with [aceoledb.dll!getmodulemsosynchronizer+0x28a73]

error

I closed the connection after all the operation was done like below:

......
connXLS.Close 
Set connXLS = Nothing

How can I resolve this problem ?

Environment:

  • OS: Windows Server 2016 Datacenter(1607) 64bit
  • IIS : Ver10.0.14393
  • Excel(server) : Excel 2016(32 bit)
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,368 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
{count} votes