Skip to main content
Question

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

  • February 28, 2024
  • 3 replies
  • 2116 views

Forum|alt.badge.img+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
 

3 replies

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Automation Anywhere Team
  • 566 replies
  • February 28, 2024

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.


Forum|alt.badge.img

Hello 

Can you try to check your strings. the file path need to use “”

provider=microsoft.ace.oledb.12.0;data source="filefullpath";Extended Properties="Excel 12.0;HDR=YES;IMEX=1";

My environment is proceeded using string above.


shaikhasif
Most Valuable Pathfinder
Forum|alt.badge.img+7
  • Most Valuable Pathfinder
  • 76 replies
  • July 4, 2024

Can you try this :

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$vInputFilePath$;Extended Properties="Excel 12.0 Xml;HDR=YES"

 

Also check this below check box of 64 bit driver present in connect step :

Thanks,

Asif


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings