Skip to main content
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.

  • Oct 6, 2022 11:13 AM UTC
  • 6 replies
  • 765 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

Forum|alt.badge.img+11
  • Most Valuable Pathfinder
  • Oct 6, 2022 3:54 PM UTC

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>


  • Navigator | Tier 3
  • Oct 7, 2022 1:25 AM UTC

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
  • Oct 7, 2022 1:57 AM UTC

image


  • Cadet | Tier 2
  • Oct 11, 2022 12:59 PM UTC

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
  • Mar 20, 2023 11:51 AM UTC

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

 

Anyone found solution for this issue , kindly share.


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