Question

Issue with SQL DB Connection

  • 27 June 2022
  • 3 replies
  • 52 views

Badge +1

I am trying to connect to Database

Provider=MSOLEDBSQL;UID=XXXXX;PWD=XXXX;Database=RPA_BOT_DB;Server=10.190.5.33\QMSSQL,1433

But getting error

 

Could you please help us to connect to DB


3 replies

Userlevel 3
Badge +7

Hi @VENKATARAO MARADA​ ,

 

Please find the below link,

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-using-database-connect-action.html/p>

 

https://www.connectionstrings.com/sql-server//p>

Badge +1

Still Unable to connect

Userlevel 3
Badge +7

To access any database through ODBC, you must first install a 32-bit ODBC driver on your device.

 

Please install it and give a try

 

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16/p>

 

 

Reply