Question

Could not Connect to Database. Provider cannot be found. It may not be properly installed.

  • 28 February 2024
  • 1 reply
  • 445 views

Badge +2

Hi Team,

 

Please help here why getting error when try to connect database with help of A360 and retrieve the data from excel file using this code:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Ajit Singh\RPA\Book2.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES"

 

This may be due to the following reason:

Could not Connect to Database. Provider cannot be found. It may not be properly installed.
Location: DatabaseSession (line 1)
To continue, edit the bot and fix the error. Then, try again.
If you continue to see this message, please contact your system administrator.
Code: bot.execution.error
 


1 reply

Userlevel 4
Badge +6

I can replicate the message. It could be that we are both using the 64-bit version of Office (and the ACE data source) and we need the 32-bit version. You cannot install the 32-bit version when the 64-bit version is installed… I tried it already.

Using Excel as a database is not ideal. Can you put this information into an Access database instead? Then you wouldn’t need the custom connection string.

Reply