Skip to main content

Hi All,

I have installed Microsoft access database engine 2016 (64 bit) and I have Excel 2019 version. Still facing connection issue like. ‘Could not Connect to Database. Error number: 80004005 Failure creating file.’ If I uncheck the ‘Use ODBC 64-bit driver for connection’ then error is changing to this - ‘Could not Connect to Database. Provider cannot be found. It may not be properly installed.’

 ​@Automation Anywhere Team Please suggest some solution and let me know if any other details required from my end.

Configurations
Database engine version 

Thanks,

Tamal

Have you verified that it’s been installed correctly? If you type `ODBC` into the start menu and open up the ODBC Data Sources (check both 32-bit and 64-bit) you should see:

Also worth referring back to the awesome QuickTip.

Hi ​@OliverM108256 

Thanks for your quick response.

I have checked those drivers in my system, 32 bit one is not present but 64 bit one is there. Should I need both?

Please suggest.

 

Thanks,

Tamal

That’s great you just need one installed but make sure you untick the 64-bit driver checkbox in the image you shared.

Reply


Terms & ConditionsCookie settings