Skip to main content
Ground Control | Tier 1
October 6, 2022
Question

Connect command in DB gets stuck without execution or throwing exception in A360. need some assistance reinstalled OLEDB, tried restarting the BOT services, but unable to get rid of this issue.

  • October 6, 2022
  • 6 replies
  • 748 views
Connect command in DB gets stuck without execution or throwing exception in A360. need some assistance reinstalled OLEDB, tried restarting the BOT services, but unable to get rid of this issue.

    6 replies

    Most Valuable Pathfinder
    October 6, 2022

    Are you connecting Excel as a DB? I'd recommend checking out below tutorial

     

    https://developer.automationanywhere.com/blog/quicktip-connect-to-an-excel-spreadsheet-as-a-database/p>

    Chand
    Navigator | Tier 3
    October 7, 2022

    Hi @Hareesh Rajasekaran​ 

     

    Just checked the documentation and found this:

    Microsoft does not support OLEDB drivers for automation.

     

    More Info:

    Connecting to a database (automationanywhere.com)

     

    Navigator | Tier 3
    October 7, 2022

    image

    Cadet | Tier 2
    October 11, 2022

    I am also having same issue. It get stuck when machine on particular line for connecting database. and the thing is I am connecting to same database multiple time but only at that particular line it get stuck. I make sure all time that its disconnected properly before connecting again but this issue is wired. If some one can help

    Cadet | Tier 2
    March 20, 2023

    @hareeshr /  @patelraj Did you got solution for this issue? 

     

    Anyone found solution for this issue , kindly share.

    Cadet | Tier 2
    April 17, 2023

    I am also facing the same issue. This is impacting our project performance. Did anyone get any solution for this?