locked
Issue Release Dispatch Blocking RRS feed

  • 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()

    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.

    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.

    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