Answered by:
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() - Edited by Sebastien_Auroux Tuesday, March 3, 2020 5:16 PM
- Moved by Jeanine ZhangMicrosoft contingent staff Wednesday, March 4, 2020 3:00 AM
- Moved by Dan GuzmanMVP Friday, March 6, 2020 3:01 AM Move thread to more appropriate forum
Tuesday, March 3, 2020 3:04 PM
Answers
-
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 MSDNFSF@microsoft.com.- Marked as answer by Sebastien_Auroux Thursday, March 5, 2020 8:38 AM
Thursday, March 5, 2020 7:21 AM
All replies
-
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
Wednesday, March 4, 2020 3:00 AM -
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
Wednesday, March 4, 2020 8:32 AM -
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 MSDNFSF@microsoft.com.- Marked as answer by Sebastien_Auroux Thursday, March 5, 2020 8:38 AM
Thursday, March 5, 2020 7:21 AM -
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 ?Thursday, March 5, 2020 8:39 AM
-
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 MSDNFSF@microsoft.com.Thursday, March 5, 2020 9:22 AM -
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, esquel@sommarskog.se
Thursday, March 5, 2020 10:12 PM -
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
Friday, March 6, 2020 3:02 AM -
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
Monday, August 3, 2020 8:49 AM