Issue Release Dispatch Blocking

Question

i have an MFC application connecting to ms access. sometimes the connection.close fails and is blocking the entire application. This issue is happening with 1909 windows version (and we never get this error with 1903 version)

here is the complete stack trace : (i have a dump file if necessary)

     

ntdll.dll!_NtWaitForMultipleObjects@20()

KERNELBASE.dll!WaitForMultipleObjectsEx()

mso20win32client.dll!65e32850()

[Les frames ci-dessous sont peut-être incorrects et/ou manquants, aucun symbole chargé pour mso20win32client.dll]

AcLayers.dll!NS_FaultTolerantHeap::APIHook_RtlFreeHeap(void *,unsigned long,void *)

mso20win32client.dll!65d53a44()

mso40uiwin32client.dll!64479086()

mso50win32client.dll!6437940a()

mso.dll!621ed2c0()

ACECORE.DLL!798b6a26()

ACECORE.DLL!798525c5()

ACEOLEDB.DLL!7973c822()

ACEOLEDB.DLL!7973ccdd()

ACEOLEDB.DLL!7973a703()

ACEOLEDB.DLL!7973b283()

ACEOLEDB.DLL!79741fdc()

oledb32.dll!CAcm::FinalRelease()

oledb32.dll!CACMDynamic<class CDCM>::CmFinalRelease(void)

oledb32.dll!ATL::CComPolyObject<class CDCM>::Release(void)

oledb32.dll!CDCMPool::DestroyResource(unsigned long)

comsvcs.dll!CHolder::SafeDispenserDriver::DestroyResource()

comsvcs.dll!CHolder::Close()

oledb32.dll!CDCMPool::DetachFromHolder()

oledb32.dll!CDCMPoolManager::ScavangePools()

oledb32.dll!CDCMPoolManager::Release()

oledb32.dll!ATL::CComObject<CMSDAInitialize>::Release()

msado15.dll!CConnection::Term()

msado15.dll!ATL::CComObject<CConnection>::Release()

BAT_EMC3.exe!COleDispatchDriver::ReleaseDispatch() Ligne 155

BAT_EMC3.exe!COleDispatchDriver::~COleDispatchDriver() Ligne 131

BAT_EMC3.exe!_Connection::~_Connection()

BAT_EMC3.exe!_Connection::`scalar deleting destructor'(unsigned int)

BAT_EMC3.exe!CloseDB(_Connection * pConnection) Ligne 130

BAT_EMC3.exe!GetOptionsPath(bool bLMProfile, ATL::CStringT<wchar_t,StrTraitMFC<wchar_t,ATL::ChTraitsCRT<wchar_t> > > sSection, ATL::CStringT<wchar_t,StrTraitMFC<wchar_t,ATL::ChTraitsCRT<wchar_t> > > sParametres, ATL::CStringT<wchar_t,StrTraitMFC<wchar_t,ATL::ChTraitsCRT<wchar_t> > > sDefaultPath) Ligne 264

BAT_EMC3.exe!CBAT_EMCApp::CheckUpdate() Ligne 1293

BAT_EMC3.exe!CBAT_EMCApp::InitInstance() Ligne 269

BAT_EMC3.exe!AfxWinMain(HINSTANCE__ * hInstance, HINSTANCE__ * hPrevInstance, wchar_t * lpCmdLine, int nCmdShow) Ligne 37

BAT_EMC3.exe!wWinMain(HINSTANCE__ * hInstance, HINSTANCE__ * hPrevInstance, wchar_t * lpCmdLine, int nCmdShow) Ligne 26

BAT_EMC3.exe!invoke_main() Ligne 123

BAT_EMC3.exe!__scrt_common_main_seh() Ligne 288

BAT_EMC3.exe!__scrt_common_main() Ligne 331

BAT_EMC3.exe!wWinMainCRTStartup() Ligne 17

kernel32.dll!@BaseThreadInitThunk@12()

ntdll.dll!__RtlUserThreadStart()

ntdll.dll!__RtlUserThreadStart@8()

Answer 1

Hi,

This forum is about the Visual C++ IDE, libraries, samples, tools, setup, and Windows programming using MFC and ATL. For your case which is more related to SQL Server Data Access, I will help you move thread to SQL Server Data Access forum for better support.

Best Regards,

Jeanine Zhang

Answer 2

Hello, 

my problem is not related to sql server but to ms access. is there a forum for oledb / ado for connecting to access. I also posted my question in access forum but apparatly it is not the place neither :

https://techcommunity.microsoft.com/t5/access/issue-release-dispatch-blocking/m-p/1204785/highlight/false#M1081

Answer 3

Hi Sebastien_Auroux, 

Welcome to SQL Server > SQL Server Data Access. 

Per your description , your issue is not related to SQL Server . Sorry that I am not authorized to move your question to the appropriate forum. 

Please close this thread according kindly mark the helpful replies or your own reply as answers. By doing so, it will benefit all community members who are having this similar issue.  Your contribution is highly appreciated. 

Best Regards,

Rachel 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

where is the appropriate forum ? ms access forum doesnt want to help, mfc forum doesnt want help, sql server doesnt want to help, where can i found support from microsoft ?

Answer 5

Hi Sebastien_Auroux, 

Sorry that I told you to post your issue in the corresponding forum .I would like to help you every much but I know little about MS Access and MFC. If you have any issue  about SQL Server Data Access, please tell me freely. 

So I will advice you to post your question to the appropriate forum. MS Access Forumn  OR  Visual C++ Forum Maybe you can describe your issue in more detail so that they can locate cause. And then you will get more professional help . Also ,I think they are very willing to help you.

Thank you in advance for your patience.

Best Regards,

Rachel 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 6

where is the appropriate forum ? ms access forum doesnt want to help, mfc forum doesnt want help, sql server doesnt want to help, where can i found support from microsoft ?

As Rachel said, this a forum for SQL Server, not for Access. The moderator that moved you hear from the C++ forum apparently had no clue at all.

This problem is way out of my league, but I suspect that it is very difficult to find a forum where someone knows enough to help you with the problem. I think you are better off with opening a case with Microsoft, although that can also be an experience where you are sent around between different teams.

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 7

where is the appropriate forum ? ms access forum doesnt want to help, mfc forum doesnt want help, sql server doesnt want to help, where can i found support from microsoft ?

Sorry you're getting the run-around. It seems the C++, MVC, Access technology stack you are using isn't easily pigeonholed into a single forum. It is certainly not SQL Server Data Access, though.

As it seems to be more related to MS Access than C++/MFC, I moved this thread to MS Access.

---

Dan Guzman, Data Platform MVP, http://www.dbdelta.com

Answer 8

i solved my issue by desabling the pooling, insert this in the connectionstring : ";OLE DB Services = -2"; 

see https://docs.microsoft.com/fr-fr/archive/blogs/selvar/ole-db-resource-pooling for more information